MySql Find/replace

UPDATE yourtable SET targetfield = REPLACE(targetfield, “foo”,“bar”);

This statement will replace all occurrences of the string “foo” with the string “bar” in all records of the “ targetfield” column. Apart from the string “bar” the rest of the text contained in the field will be unchanged.