title: MySQL - ORDER BY values within IN()
body: <p>I'm hoping to sort the items returned in the following query by <strong>the order they're entered into the IN() function</strong>.</p>
  
  <p>INPUT:</p>
  
  <pre><code>SELECT id, name FROM mytable WHERE name IN ('B', 'A', 'D', 'E', 'C');
  </code></pre>
  
  <p>OUTPUT:</p>
  
  <pre><code>|   id   |   name  |
  ^--------^---------^
  |   5    |   B     |
  |   6    |   B     |
  |   1    |   D     |
  |   15   |   E     |
  |   17   |   E     |
  |   9    |   C     |
  |   18   |   C     |
  </code></pre>
  
  <p>Any ideas? </p>