title: mysql SQL: specific item to be first and then to sort the rest of the items
body: <p>Lets say I have the table below.</p>
  
  <p>I want to get all the friends, but I want the id 5 to be the first item in the list. I don't care about the order that I receive the rest of the items.</p>
  
  <p>The desired query result will be:</p>
  
  <pre><code>friends
  -------
  
  id    name
  
  5     nahum
  1     moshe
  2     haim
  3     yusuf
  4     gedalia
  6     dana
  </code></pre>
  
  <p>How can I do this?</p>
  
  <p>using Mysql 5.1.x.</p>
  
  <p>Thanks!</p>