quick mysql order by problem

[Anon]

ok i have a script and theres a mysql database that has liek probly 1000+ rows in it it orders it by a number like say 70 should be at the top and below that like 69 will if there is like a 9 it puts that above the 70 any ideas? all help is appreciated..

[Anon]

like...omigod

[Anon]

quit being a fag can someone who has a life answer me....

[Anon]

Here is a syntax for you to try, using one of these:
order by asc; (ascending)
order by desc; (descending)

select * from my_table where what_i_want > 5 and what_i_want < 10 order by what_i_want asc;

that will give you the following, in this order:
6
7
8
9

[Anon]

I am the famous Noerd Joeller, developer of the Institute of Joellerchan Stochiastic Mathematical Analysis, director of theoretical studies, and major in astromechanics; I will not be spoken to in this manner.

[Anon]

Well, that is one of the more confused and run-on sentences I've seen in a long while. It reads like someone who's been smoking way too much of something they shouldn't have. Or a, like, Californian.

[Anon]

Sounds like the number values are being stored in a varchar or character type column. So his data sorts like:

9
80
71
69
5
40

Needs to convert to a numeric column type to have sql sort in numerical order.

Of course, there's always the possibility that I am misreading that first (or is it last) sentence.