order by id issue

[viveleroi0]

I have a mysql database with over 1000 product IDs. I am trying to sort the query by ID, but this happens:

I want to have the IDs displayed like:

1, 2, 3, 4, 5... 1000 etc

But, what happens, is mysql displayes it like:

1, 1000...1999, 2, 2000-2999, 3, 3000-3999

which screws everything up. This is just like windows numbering. How can I fix it so that it will sort like the first example?

[LordShryku]

What field type is that?
You could put them in an array nad use [man]natsort[/man], but an interger field should sort it right (I think).

[Sxooter]

Well, it's text, not a number (you're obviously using a varchar or text field to store it) so the database is sorting according to the rules for a text sort.

If you're on a fairly late model MySQL (or any other database in the universe like firebird or postgresql) you can cast the row to an int to order by it:

select * from table order by cast(id as int);