Apr 12 2010

Replace text with a MySQL SQL statement

Many times you will need to replace or reformat some data in your MySQL table. The replace can be done quickly with the MySQL REPLACE() command that looks like:
UPDATE `table_name` SET `field_name` = REPLACE(`field_name`, 'text to replace', 'new text');
Always make sure to update your tables before running any updates.