http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

SELECT * FROM t1
ORDER BY_`key_part1`_,_`key_part2`_,... ;

SELECT * FROM t1
WHERE_`key_part1`_=_`constant`_
ORDER BY_`key_part2`_;

SELECT * FROM t1
ORDER BY_`key_part1`_DESC,_`key_part2`_DESC;

SELECT * FROM t1
WHERE_`key_part1`_=1
ORDER BY_`key_part1`_DESC,_`key_part2`_DESC;