in select query, listing specific result first

[toodi4]

I'm running a simple select query in mysql that orders results by the most recent:

select * from table order by time desc

What I'm trying to do is modify this slightly. I want to display some specific results at the top based on specific criteria. I'm hoping I can do this within one query, but I'm not sure.

So the criteria for the results at the top would be:

where status=2 and time > $time_constraint

Obviously, I can run 2 queries:

q1 = select * from table where status=2 and time > $time_constraint order by time desc

q2 =select * from table order by time desc

But is there a way to combine this into one?

[LordShryku]

Try using a conditional statement to set a value to order by.

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html

   SELECT fields,
          IF(status = 2 AND time > $time_constraint, time, 0) AS sorter
     FROM table 
ORDER BY sorter, time desc