SQL

mysql remove last character

LEFT(col,length(col)-1) 

remove last characters in mysql

UPDATE <table_name>
SET <column_name> = CONCAT(LEFT(<column_name>, CHAR_LENGTH(<column_name>) -1), '')
WHERE <condition>;