Adding leading zeros to a number

Question

I was wondering if there was a way to add leading zeros to numbers when selected that are less than 4 characters and cast as a string.

I appreciate any advice, thanks in advance!

Something like:

SELECT PAD(CAST(last4 as string), 4) as last4 from numbers

Desired output:

1 => 0001
100 => 0100
112 => 0112
15 => 0015

Answer 1

You were very near:

SELECT LPAD(last4, 4, '0') as last4 FROM numbers;

see https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_lpad