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

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,')