title: mysql forcing a record to the top
body: <p>I am getting a list of people attending a course from a courses2011 table, the query is working but the client has asked us to make the person doing the query (they are logged in to the website) appear on top of the list. People won't be on the course for the full time hence the dates in my query.</p>
  
  <p>Here is my current query:</p>
  
  <pre><code>select firstname, lastname, startdate, enddate, contactid, courseid, venueid from courses2011 where courseid = '4' 
  and ((enddate &gt; '2011-05-01') AND (startdate &lt; '2011-05-20'))"
  </code></pre>
  
  <p>Say contactid "12345" is logged in to the site - How to I make a query so they appear first in the list.</p>