How to Search and Replace/Find and Replace Data in MySQL

To search/find a string in a certain field and replace it with another string in mysql sql:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

 

Visit sunny St. George, Utah, USA