Sort by Multiple Fields in Different Directions?

[Actorial]

Hi,

I'm wondering if I can sort by multiple categories in different directions. I tried this and it doesn't work:

SELECT * FROM table ORDER BY field1 DESC ORDER BY field2 ASC LIMIT 0,10

And it doesn't work, any advice?

 

[Actorial]

nevermind, i solved my own prblem, just was missing commmas after each ASC or DESC!

 

[guelphdad]

you can't have two separate order by clauses in there of course, just the list of the columns and as you say separated by a comma.

select 
foo,
bar
from yourtable
order by foo asc, bar desc

and to save a few keystrokes ascending is the default so you don't have to note that.