code_junkie

(MySQL) OrderBy Field1=3, Field2

Nov 13th, 2011
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT * FROM Books ORDER BY (year = 1990) DESC, name
  2.  
  3. ORDER BY
  4. CASE WHEN Field1 = 3 THEN 0 ELSE 1 END ASC,
  5. Field2 DESC
Add Comment
Please, Sign In to add comment