SQL Function Reference

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