I needed a way to trim the three left side characters. I’ll save you the long boring story about why – here’s the how: SELECT LEFT( price , CHAR_LENGTH( price ) -3 ) AS price FROM products This gave me 150 instead of 150000.
A Resource for Very Little