title: How do you keep the order using SELECT WHERE IN()?
body: <p>Is there a way to keep the order when using SELECT WHERE IN()? For example, using the following query:</p>
  
  <pre><code>SELECT id FROM data_table WHERE id IN(56,55,54,1,7);
  </code></pre>
  
  <p>The results will come back using the default order by id. 1,7,54,55,56</p>
  
  <p>When I want to keep the order used in the IN: 56,55,54,1,7</p>
  
  <p>Is there a quick way to do this in MySQL or will I be forced to order it after in code?</p>