title: How to make MYSQL query results ORDER BY conditions order?
body: <p>My query string is like:</p>
  
  <pre><code>SELECT ... FROM maintable
  LEFT JOIN table1 on (maintable.id = table1.idx)
  LEFT JOIN table2 on (table1.idy = table2.idy)
  LEFT JOIN table3 on (table2.idz = table3.idz)
  WHERE (condition1 OR condition2 OR condition3)
  AND maintable.status = static
  
  //condition1 &amp; condition2 &amp; condition3 are kind of
  table3.idz = 101, table3.idz = 3, maintable.id IN (1,2,3,4), and so on
  </code></pre>
  
  <p>For the results I want entries that meet <code>condition1</code> to be returned first, then entries that meet <code>condition2</code>, and finally entries that meet <code>condition3</code>. Any ideas?</p>