2 order bys?

[Sayian]

I need to order a query by 2 things.

In the table , i have 2 rows which are important to my order by

time , and sticky.

I need to order by sticky's first, so if sticky = 1 it is shown at the top of the list .. then once all the stickys are displayed i need to order the rest of the rows by time DESC

how would this be possible?

[laserlight]

ORDER BY col1, col2 DESC

would order the rows in the result set by col1 first, followed by col2 in descending order.