Replacing strings in MySQL

Use REPLACE. For example:

REPLACE( haystack , 'find' , 'replace' )