Page 1 of 1

mysql remove last char

Posted: Sat Jun 11, 2022 9:34 pm
by 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.

Re: mysql remove last char

Posted: Sun Jun 12, 2022 9:18 am
by 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 '%,' ;