Just a quick reminder and example to myself really for this useful MySQL string function.
Syntax:
REPLACE( table_field, search, replace)
Example (replaces all instances of donkey with horse:
UPDATE `table` SET `table_field` = REPLACE( `table_field`, 'donkey', 'horse')