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

Get In Touch

We would love to hear from you.

Please enter your email address.
Please enter a valid email address.
Please enter the verification number.
You have entered a wrong verification number.
Please enter a message.
Please check your message for any errors.
Your message has been sent successfully.
Sorry, error occured this time sending your message.
* required