Mysql Replace – Golden

UPDATE table SET field = replace( field, ‘needle’, ‘replacewith’ ) ;