How to Find & Replace Data in MySQL
Gary Oosterhuis | January 31, 2013
![](https://www.linkweb.ca/wp-content/uploads/2013/01/mysql.jpg?x75904)
To find a string in a certain field and replace it with another string:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
Gary Oosterhuis | January 31, 2013
To find a string in a certain field and replace it with another string:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
Add a Comment