开发者

How to implement select trim(string,','); for MySQL?

开发者 https://www.devze.com 2023-01-05 21:07 出处:网络
mysql> select trim(\',hi,test,\',\',\'); ERROR 1064 (42000): You have an error in your SQL syntax; I wan开发者_如何转开发t to trim by , but seems not supported by MySQLCheck the doc...
mysql> select trim(',hi,test,',',');
ERROR 1064 (42000): You have an error in your SQL syntax;

I wan开发者_如何转开发t to trim by , but seems not supported by MySQL


Check the doc...

SELECT TRIM(BOTH ',' FROM ',hi,test,')
0

精彩评论

暂无评论...
验证码 换一张
取 消