[TYPO3] mysql ordering

[Christian Tauscher]

Lübke Pedderson schrieb:

> When I call records from DB and say "ORDER BY NUMBER"
> It gives me the number field always in order like
> 1
> 10
> 100
> 101
> 
> But how can I make the order like
> 1
> 2
> 3
> 4
> 5
> 6
> etc...

What is the difference?

Numbers beginning with the small ones up to the bigger ones.
Perfekt.

> What am i missing?

Good question.

eg. 2-9 and 11-99 and so on?
Is is possible these numbers don't exist ind your DB?

Christian.