Home > MySQL > How to Find and Replace Text in a MySQL Database using SQL
Bookmark and Share

How to Find and Replace Text in a MySQL Database using SQL

Posted on September 15, 2012 | Filed in MySQL

update TABLE_NAME set COLUMN_NAME = replace(COLUMN_NAME, ‘String to be Matched’, ‘New String’);

Example:
update My_Clients set Company_Name = replace(Company_Name, ‘Apple’, ‘Google’);

Leave a Reply