PHP and MySQL - Find and Replace - Update

[Barry]

Tweet

Hi all

I have a database with all the product feeds from TD, AW and Buyat lobbed in and I want to search through it and 'find and replace' a certan text string in the 'ProductImage' field.

Does anybody know of the SQL command I can run in order to achieve this.

For any examples please use the following format, so i can understand (it also describes the basic function i would like)

Find 'foo1' in field named 'ProductImage' and replace with 'foo2'.

Thanks in advance for any help.

[Kandevil]

update tablename set ProductImage = "foo2" where ProductImage = "foo1";

[Barry]

THANKS SO MUCH





Sorry for shouting but thats 'soooooo' easy to understand.


I thought it was going to be a long old complexed piece of code.


Nice One

Cheers - made my day.