sort by column 1 then by column 2

[jasonc]

sorting results got from mysql.

 

i wish to sort results by the columns ID then by NUMBER,

both with the highest numbers first.

 

i have this mysql code so far but it firstly sorts the ID column but has 99 above 990 !

 

can i sort so it is strict number order?

 

select * from `list` ORDER BY `number` DESC LIMIT 600

[luca200]

It would be very strange if it sorted the id columns, given you wrote "ORDER BY number".

Your clause should be ORDER BY id desc, `number` desc, but if columns are not numeric, of course you'll get 99 before 990. In that case you should do this

 

SELECT *, cast(id as integer) as numid, cast(`number` as integer) as numnumber ORDER BY numid desc, numnumber desc

[jasonc]

ok i see how this works..

 

but where is the table info it is searching?