title: How to put row on top in mysql query.
body: <p>Hi i have 100 records in my SQL table i want to sort them ASC by name but i need one record on top of all record nr 43.</p>
  
  <p>Is there way i can pull this record 43 first and then everything else ASC order by name?</p>
  
  <p>Trick is to do it in one query.</p>