How to get a records based on two conditions and second condition must be checked only if first one failed?

Question

Hello! Is there a way to get a records in single query based on two conditions and second condition must be cheked only if first one failed. For example how can I get all records where time > NOW() and if there are no such records to get a record with max(id).

Answer 1

http://dev.mysql.com/doc/refman/5.0/en/case-statement.html