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
<str>The string.
<from_str>The from string.
<to_str>The to string.

Return Type​

VARCHAR

Examples​

SELECT REPLACE('www.mysql.com', 'w', 'Ww');
+-------------------------------------+
| REPLACE('www.mysql.com', 'w', 'Ww') |
+-------------------------------------+
| WwWwWw.mysql.com                    |
+-------------------------------------+
Did this page help you?
Yes
No
Join our growing community
GitHub
🌟 7.3K Stars
Slack
Twitter
YouTube
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today