mysql remove last character from string code example
Example 1: mysql remove last empty newline
update mytable SET title = TRIM(TRAILING '\n' FROM title)Example 2: mysql remove last character
LEFT(col,length(col)-1)update mytable SET title = TRIM(TRAILING '\n' FROM title)LEFT(col,length(col)-1)