Function Reference

REPLACE

Returns a string in which all substrings have been replaced by another substring

MySQL 8.1

REPLACE(str, from_str, to_str)

str

Source string

from_str

Substring to be replaced

to_str

The substring that will replace

Examples

MySQL 8.1

SELECT REPLACE('Dear msr Wilson', 'Wilson', 'Brown');