REPLACE
Returns a string in which all substrings have been replaced by another substring
REPLACE(str, from_str, to_str)
from_str
Substring to be replaced
to_str
The substring that will replace
Examples
SELECT REPLACE('Dear msr Wilson', 'Wilson', 'Brown');