truncate left characters mysql code example Example: truncate left characters mysql SELECT TRIM(LEADING '0' FROM phone_number );