Find & Replace in MySQL
To find and replace in a MySQL database, use the following SQL statement:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html
