mySQL search and replace

UPDATE ´tablename´ set field = replace(field, ’searchString’, ‘replaceString’);