Mysql Display four(4) digit numbers

Question

In Mysql I want to display numbers using 4 digit patterns. example :

select 1    => result : 0001
select 2    => result : 0002
select 25   => result : 0025

How can I achieve this?

Answer 1

Try using lpad() function

demo

SELECT LPAD(columnanme, 4,'0');

Output:

LPAD('11', 4,'0')
0011

Answer 2

You could use the lpad function to pad zeroes to the left of the result:

SELECT LPAD(mycol, 4, '0')
FROM   mytable