MySQL search and replace

This is a simple SQL query to perform search and replace in a MySQL table

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