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 priceFROM products
This gave me 150 instead of 150000.
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 priceFROM products
This gave me 150 instead of 150000.