title: MySQL specifying exact order with WHERE `id` IN (...)
body: <p>Is there an easy way to order MySQL results respectively by WHERE <code>id</code> IN (...) clause?
  Example:</p>
  
  <pre><code>SELECT * FROM articles WHERE articles.id IN (4, 2, 5, 9, 3)
  </code></pre>
  
  <p>to return</p>
  
  <pre><code>Article with id = 4
  Article with id = 2
  Article with id = 5
  Article with id = 9
  Article with id = 3
  </code></pre>
  
  <p>and also</p>
  
  <pre><code>SELECT * FROM articles WHERE articles.id IN (4, 2, 5, 9, 3) LIMIT 2,2
  </code></pre>
  
  <p>to return</p>
  
  <pre><code>Article with id = 5
  Article with id = 9
  </code></pre>
  
  <p>Update: to be more specific, I want to avoid tampering with the data in parentheses in <code>WHERE articles.id IN (4, 2, 5, 9, 3)</code>, since those IDs are dynamic and automatically ordered.</p>