Hi, Ashley M. Kirchner wrote:
Is there a way to automatically pad a query result? For example: select id, user from table +-----+--------------+ | id | user | +-----+--------------+ | 3 | Tinker Bell | | 11 | Peter Pan | | 7 | Dumbo | | 121 | Mickey Mouse | +-----+--------------+ What I really want is: +-------+--------------+ | id | user | +-------+--------------+ | 10003 | Tinker Bell | | 10011 | Peter Pan | | 10007 | Dumbo | | 10121 | Mickey Mouse | +-------+--------------+
Sure. select 10000 + id as id, user from table. There is also an LPAD() function.
Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]