There is a bug as using internal function of MySQL named REPLACE(). One error message will display in screen, detailed message as follow:
mysql> SELECT REPLACE('www.lvtao.net', 'www', 'http://www');
ERROR 1064 (HY000): errCode = 2, detailMessage = Syntax error in line 1:
SELECT REPLACE('www.lvtao.net', 'www', 'http://www')
^
Encountered: REPLACE
Expected: REPLACE is keyword, maybe REPLACE
1条答案
按热度按时间yhxst69z1#
There is no replace function in Doris. But there is a
regexp_replacefunction in Doris which provides similar function.