Stump of a Muffin

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.

Comments are closed.