title: SQLite and custom order by
body: <p>I have a table with categories: </p>
  
  <pre><code>ID  Category
  "1","Baking"   
  "3","Family"   
  "4","Entertaining"   
  "5","Children"   
  "6","Desserts"   
  </code></pre>
  
  <p>Now I would like to order the result of the select statement to</p>
  
  <pre><code>ID  Category
  "4","Entertaining"   
  "3","Family"  
  "1","Baking"   
  "5","Children"   
  "6","Desserts"  
  </code></pre>
  
  <p>for example. In MySQL, you'd do it like this:</p>
  
  <pre><code>SELECT * FROM CATEGORIES ORDER BY FIELD (ID, 4,3,1,5,6);
  </code></pre>
  
  <p>How would you do it in SQLite though? I don't have an "order by" field.</p>