Trim commas with MySQL?

Question

I have a list of keywords as shown below, and some keyword lists in the database have leading or ending ,

keyword,keyword,keyword,keyword,

How to trim leading and / or trailing ,using mysql?

I tried to use trim, but I can’t get it to work with UPDATEwhat I'm trying to achieve.

Answer 1

 TRIM(BOTH ',' FROM ',keyword,keyword,')

The above will return 'keyword,keyword'.

BOTHcan be replaced either LEADINGby or TRAILINGif you just want to trim one side of the string.

Documentation

• MySQL 5.0 Reference Manual :: 11.5 String Functions :: TRIM

---

UPDATE TRIM, - . TRIM , .

---

','

UPDATE `table_name` SET `keywords` = TRIM(TRAILING ',' FROM `keywords`);

Answer 2

UPDATE table SET column = TRIM( BOTH  ',' FROM  'a,b,c,d,' )

. cf: http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_trim