Find and replace mysql

update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);

Make sure and remove the [] tab when entering the variable.

If you know how to do this database wide without needing the table listed please post in the comments.