title: mySQL different ORDER BY based on different WHERE
body: <p>I could run the each query separately and then output the data immediately following each other but I am hoping there is a way to do it in one query.</p>
  
  <p>I am looking for all the records to be displayed but have all records with <code>col_1=""</code> at the top and sorted accordingly and then below that have all records with <code>col_1!=""</code> sorted accordingly (different than the fist <code>order by</code>)</p>
  
  <p>I am hope I explained it ok.</p>
  
  <p>Here are 2 sample queries that I would like handled as I described.</p>
  
  <pre><code>Select * from table where col_1 ="" order by col_5,col_4,col_3;
  Select * from table where col_1!="" order by col_3,col_4,col_5;
  </code></pre>