MySQL Hint: REPLACE / UPDATE 

Replace strings with SQL in a field for all rows …

 
UPDATE `table` SET `field` = REPLACE(`field`, 'search string', 'replace with this') WHERE 1=1;

via @vogrim