DESC problem

[Anon]

Hi All,
I got a problem on DESC.If I only type ""Select * from table1 order by number DESC"", mysql would only arrange the data into the number order.Eg.:17,168,15,10

How to make it to :168,17,15,10?

Thanks!

[[deleted]]

Looks like the column 'number' is a string type (CHAR or VARCHAR) in your database. Change it to type INTEGER.

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/