UPDATE table_name SET column_name = REPLACE(column_name, 'text to find', 'text to replace with') WHERE column_name LIKE '%text to find%';