title: mysql - order by field not working properly
body: <p>suppose I've a database , the table contains rows with ides from 1 to 20 . </p>
  
  <p>i want to return 3 rows with id 3,4,1 first and then return the other rows . this is my code :</p>
  
  <pre><code>    SELECT id
  FROM prod
  ORDER BY field( id, 3, 4, 1 ) 
  LIMIT 20
  </code></pre>
  
  <p>this is the result of this code :</p>
  
  <pre><code>id
  13 
  17 
  16 
  15 
   7 
   6 
   5 
   2 
   3 
   4 
   1
  </code></pre>
  
  <p>strangely the 3 rows that I need to come first are showing at the end ,</p>
  
  <p>How can I bring these 3 rows to the top of the list ?</p>
  
  <p>Thanks </p>