Order By Largest Num. -> Smallest Num.

[xmatthawkx]

Hey all,

I've having a bit of a problem using ORDER BY in one of my mysql SELECT queries. I need to sort my results by largest number to smallest number, but mysql is returning my results in alphabetical order (I guess this is what I can call it :p).

My results from this query:

SELECT * FROM table WHERE this='that' ORDER BY numbervalue DESC

Returns:

1
2
3
4
40
45
5
60
7
71

etc...

I'd like it to return:

71
60
etc...

If anyone can help me with this, I would really appreciate it! Thanks for your time!

• Matt

[Lars_Berg]

Store the value as a integer instead of using varchar.

[xmatthawkx]

Thanks, that did the trick. 🙂 I should have seen it sooner.