I have 2 x int cols in a table in which user has to specify starting and ending numbers of a range. It can be anything, like in some cases its going to be: 000001 to 999999. But as soon as 000001 is added into mysql, it changes it to "1", meaning all 0's are omitted.
How can this be preserved ? If somehow this is preserved, then when I have to query the db for a number like say: 000123 then how to search for it ??