VeloDB Cloud
SQL Manual
Functions
string-functions
replace

replace

Description

Syntax:

VARCHAR REPLACE (VARCHAR str, VARCHAR old, VARCHAR new)

This function replaces all old substring in the str with new substring.

Example

mysql> select replace("http://www.baidu.com:9090", "9090", "");
+------------------------------------------------------+
| replace('http://www.baidu.com:9090', '9090', '') |
+------------------------------------------------------+
| http://www.baidu.com:                                |
+------------------------------------------------------+

Keywords

REPLACE