To remove the last characters from values in a MySQL column, you can use the LEFT() function along with the LENGTH() function to achieve this :-

UPDATE employee SET address = LEFT(address, LENGTH(address) – 1);

 2,378 total views