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