title: Order by more than one column with mysql
body: <p>The below shown is my query I need to <strong>order by</strong> with these three columns . This is for complex search listing. If I used one of them ,it works perfectly . But handling more than one ,it does not order properly.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Actually I needed ,premium records must be at first positions along with more favorites , and also elite customers have more priority .
  These all works conditionally </p>
  
  <p>1) More favorites will come at first</p>
  
  <p>2) But premium will be considered</p>
  
  <p>3) If basic will have 5 favorites ,it wont push to top ,basic having small priority</p>
  
  <p>4) As well elite have some good priority </p>
  
  <pre><code>SELECT  
     `Driver`.`id` ,  
     `Driver`.`login_id` ,  
     `Login`.`profile_type`, 
     .................
  ORDER BY  `fav_count`, 
     FIELD(  `Login`.`profile_type` ,  "premium",  "basic" ) ,  
     `Driver`.`is_elite` ASC
  </code></pre>
  
  <p><strong>Sample result I expected</strong></p>
  
  <pre><code>is_elite|       profile_type  | fav_count
  ________|_____________________|____________
  1       |        premium      |   4      
  1       |        premium      |   3 
  1       |        premium      |   2 
  1       |        premium      |   1 
  0       |        basic        |   5 
  0       |        basic        |   0
  </code></pre>
  
  <p>Please advise me . Thanks</p>