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

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