replacing text string

matbennett

Hi,

I am trying to fix some data input errors in a database, and wondered if someone could help.

I have a table called products that includes a field called products_description, a text field containing HTML.

A LOT of the records have an error in the HTML thanks to someone getting a path slightly wrong. I am hopeing to come up with a statement that will search for all occurances of the string

<img src="/image

and replace it with

<img src="image

(dropping the "/").

I don't seem to be getting very far with this. Can someone give me a pointer?

mystrymaster

UPDATE fieldname = '<img src=image' FROM tablename where fieldname = '<img src=/image'

That should do the trick for you

matbennett

Sorry, I think that this may be me being unclear.

The html snippet that I gave is just part of the field contents. For instance (and this is far shorter than the real ones), the field may contain:

Aquamarine pendant in 9ct yellow gold pendant on an 18inch 9ct gold chain.
<br><br>  

Click on the image below to view matching items
<br>  

<a href="/advanced_search_result.php?keywords=bs-mar-02">  

<img src="/images/bs-mar-02.jpg" width="100" height="100" border="0" hspace="5">  

</a>

mystrymaster

sorry wish I could help but at that point you are now over my head in sql php knowledge 😕

matbennett

OK, thanks anyway.

I know that there has to be a way to do this.

mystrymaster

there is I just don't know it - but have no fear one these guys wil l have an answer 🙂