[Resolved] reversing the order of ORDER BY

[jacksonpt]

I've got a column in a table that I use as the criteria for ordering/sorting data. The column is type varchar, however it has almost exclusively numbers in it. I don't use them mathematically, so varchar is fine for my needs - and every now and again, I do need to be able to enter a non-numerical value.

Anyways... when I do an order by on this column, the ordering is done from lowest to highest. Is there a way to reverse it... so the data is displayed from highest to lowest?

Thanks.

[mrhappiness]

http://dev.mysql.com/doc/mysql/en/select.html reveals the magic...

ORDER BY whateveryouwant DESC

[jacksonpt]

Excellent, thanks.

• note to self - start using the manual, not your crappy book to lookup stuff *