Search And Replace in MySQL

This is just mostly for my reference so I don’t have to keep digging in the Google cache to get this site:

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

I’ve probably used this bit of SQL a dozen times in the last week while doing some pruning/cleanup in a work database, I just kept forgetting the exact syntax.