Find and replace in MySQL

We use this simple query so much, we thought it was worth a mention. It's really useful when you need to replace a term or character in a large table of website content.

update [table] set [field] = replace([field],'[find]','[replace]');