mysql str_replace

UPDATE my_table SET column1 = REPLACE(column1, 'search string', 'replacement');