format column MYSQL

[Bickey]

In my MYSQL db how do I format a single or two digit number to have 0 in front? (e.g. 005, 012)

[requinix]

Do it in PHP, not MySQL.

printf("%03u", 12); // to print/echo it
$number = sprintf("%03u", 12); // to get the value

[Muddy_Funster]

Or, to do it in MySQL, set the column type to be INT (3) UNSIGNED ZEROFILL and your done.

[fenway]

Or, to do it in MySQL, set the column type to be INT (3) UNSIGNED ZEROFILL and your done.

Please don't store formatting the in the DB -- as tempting is it may be.