Sometimes we need find and replace string/text in mysql tables. Here is the sql i use and find works

UPDATE mysql_table_name SET mysql_column_nam= REPLACE(mysql_column_name, ‘string_to_find’, ‘string_to_replace’);