How to Find & Replace Data in MySQL

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

Your email address will not be published. Required fields are marked *