MySql – Find and Replace text in a table

For a single table update UPDATE `table_name` SET `field_name` = replace(same_field_name, ‘unwanted_text’, ‘wanted_text’)

 UPDATE `table_name`
 SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')
Advertisements