Cacher is the code snippet organizer for pro developers

update table_name set field_name = replace(field, 'search_string', 'replace_string') where instr(field_name, 'search_string') > 0;