Skip to main content

REPLACE

Returns the string str with all occurrences of the string from_str replaced by the string to_str.

Syntax​

REPLACE(str,from_str,to_str)

Arguments​

ArgumentsDescription
strThe string.
from_strThe from string.
to_strThe to string.

Return Type​

A String data type value.

Examples​

SELECT REPLACE('www.mysql.com', 'w', 'Ww');
+-------------------------------------+
| REPLACE('www.mysql.com', 'w', 'Ww') |
+-------------------------------------+
| WwWwWw.mysql.com |
+-------------------------------------+