Replace Text 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’);