title: MySQL Order by CASE
body: <p>I cant make it work for me. </p>
  
  <pre><code>ORDER BY cl.name ASC'); 
  </code></pre>
  
  <p>I must change to:</p>
  
  <pre><code>ORDER BY CASE cl.name WHEN "Nameone" THEN 0 WHEN "Nametwo" THEN 1 ELSE 2 END ASC
  </code></pre>
  
  <p>I get the result</p>
  
  <pre><code>1. Nameone
  2. Nametwo
  </code></pre>
  
  <p>(and the rest but its not ordered by name from A-Z but it displays i think by id)</p>
  
  <p>So how to make the rest result to be ordered by cl.name ASC?</p>