title: MySQL order by certain values even if not existing in the table
body: <p>I have a Table is looking like this </p>
  
  <pre><code> id         name
  -----      ------
  1          Mark
  2          Mike
  3          John
  4          Mike
  5          Mike
  6          John
  7          Mark
  </code></pre>
  
  <p>Notice that there isn't name Paul in the table so when ordering by name I want it to be like this ('Mark', 'Paul', 'Mike','John')</p>
  
  <pre><code>        id         name
         -----      ------
          1          Mark
          7          Mark
         Null        Paul
          2          Mike
          4          Mike
          5          Mike
          3          John
          6          John
  </code></pre>
  
  <p>I already have tried the field method and it is removing Paul because it is not in the table</p>
  
  <pre><code>ORDER BY Field(name, 'Mark', 'Paul', 'Mike','John')
  </code></pre>