MySQL search and replace

update tablename set field = replace(field,'search_for_this','replace_with_this');