title: mySQL order by certain values & then DESC?
body: <p>Say I have a mySQL table which has a field named "name"</p>
  
  <p>This field contains one name per row.</p>
  
  <p>There are 10 rows:</p>
  
  <pre><code>Apple
  Pear
  Banana
  Orange
  Grapefruit
  Pineapple
  Peach
  Apricot
  Grape
  Melon
  </code></pre>
  
  <p>How would I form a query so I select from the table, I want the details to show like this:</p>
  
  <pre><code>Peach
  Apple
  Apricot
  ... and then everything else is listed by descending order.
  </code></pre>
  
  <p>So basically I want to show a few specified results at the TOP of the list, and then the rest of the results in descending order.</p>
  
  <p>Thank you.</p>