mysql remove last char

[mister_v]

Hi,

how can i remove the last character from a string ?
Like column="a,b,c,d,"; I want to remove the last comma.

[chris]

You can use (in MySQL):

Code: Select all

SELECT column SUBSTRING(column,1,CHAR_LENGTH(column)-1) AS column_part FROM table;

You can also do an update and change all the data.
(Make a backup first ! )

Code: Select all

UPDATE table SET column=SUBSTRING(column,1,CHAR_LENGTH(column)-1) FROM table WHERe column Like '%,' ;