title: MySQL Order By Comma Separated List
body: <p>I have the following MySQL query</p>
  
  <pre><code>SELECT * FROM Characters WHERE CharacterID IN (30, 29, 1, 292, 51)
  </code></pre>
  
  <p>Which returns back my list of characters as below</p>
  
  <pre><code>|   CharacterID   |   CharacterName  |
  --------------------------------------
  |        1        |    Character 1   | 
  |       29        |    Character 29  | 
  |       30        |    Character 30  | 
  |       51        |    Character 51  | 
  |      292        |    Character 292 | 
  </code></pre>
  
  <p>I need it to return back in the same order as the original comma seperated value. So in this specific instance, I would need it to return...</p>
  
  <pre><code>|   CharacterID   |   CharacterName  |
  --------------------------------------
  |       30        |    Character 30  | 
  |       29        |    Character 29  | 
  |        1        |    Character 1   | 
  |      292        |    Character 292 | 
  |       51        |    Character 51  | 
  </code></pre>
  
  <p>Is there anyway where I can specifically say something like</p>
  
  <pre><code>SELECT * FROM Characters WHERE CharacterID IN (30, 29, 1, 292, 51)
  ORDER BY (CharacterID, specifically in the order of (30, 29, 1, 292, 51))
  </code></pre>