mysql find and replace table

How to Find & Replace Data in MySQL 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]’); (Don’t forget to remove the [] bars!) You can run this from root, ssh, or in your phpmyadmin under the MYSQL tab.