How to remove last characters in mysql column values ?

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,379 total views