title: MySQL UNION SELECT statement order by two different columns
body: <p>I have a table with a column called "myorder". I want to only order the first 5 elements in ascending order by using the column "myorder" and then the rest of the elements ordererd by id in descending order. I've tried but I don't seem to get this 100%. I have created a <a href="http://sqlfiddle.com/#!2/f66fe8/8" rel="nofollow">sqlfiddle</a> with this simple example. Can anybody help me?</p>
  
  <p>The order in the sqlfiddle should be: Blue, Brown, Yellow, Red, Green, Orange, Gray, Black, White.</p>