Stump of a Muffin

Tag: left

MySQL – LEFT

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.