REPLACE_EMPTY

replace_empty

description

Syntax

Since 2.1.5

VARCHAR REPLACE_EMPTY (VARCHAR str, VARCHAR old, VARCHAR new)

Replace all old substrings in str string with new string.

Unlike the REPLACE() function, when old is an empty string, the new string is inserted before each character of the str string and at the end of the str string.

Other than that, the other behaviors are exactly the same as the REPLACE() function.

This function is mainly used for compatibility with Presto and Trino, and its behavior is exactly the same as the REPLACE() function in Presto and Trino.

example

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

mysql> select replace_empty("abc", '', 'xyz');
+---------------------------------+
| replace_empty('abc', '', 'xyz') |
+---------------------------------+
| xyzaxyzbxyzcxyz                 |
+---------------------------------+

mysql> select replace_empty("", "", "xyz");
+------------------------------+
| replace_empty('', '', 'xyz') |
+------------------------------+
| xyz                          |
+------------------------------+

keywords

REPLACE_EMPTY