Posted by Oli Filth on 09/28/32 11:44

endlesstide@gmail.com said the following on 09/04/2006 00:02:
> hi i have the following
> ORDER BY `tabelno`
> which gives me
> 1
> 10
> 11
> 12
> 13
> 14
> 15
> 16
> 17
> 18
> 19
> 2
> 20
>
> when i want
> 1
> 2
> 3
> etc
>
> how can i achieve this?

Use a numeric datatype, like INT, instead of a VARCHAR.


--
Oli

• Next in forum: Re: My Blog Now Has Teh Video Yo
• Prev in forum: MYSQL ORDER BY question, sorting numbers
• Thread view: Re: MYSQL ORDER BY question, sorting numbers

[Reply to this message]