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