MySQL Replace String, Similar to PHP str_replace()
Very handy function if you need to replace a string in your MySQL database tables.
UPDATE table
SET field = REPLACE(field, 'Old Value', 'New Value')
Reference
MySQL String Functions
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html
