Mysql Search and Replace example

Doing search and replace in mysql, e.g.:

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