title: Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
body: <p>This might not be very sensible, but I'ld like to let MySQL return me the exact duplicate rows if there are duplicate criteria in the <code>WHERE IN</code> clause. Is this possible?</p>
  
  <p>Take this example:</p>
  
  <pre><code>SELECT
     columns
  FROM
     table
  WHERE
     id IN( 1, 2, 3, 4, 5, 1, 2, 5, 5)
  </code></pre>
  
  <p>I'ld like MySQL to return me rows with id 5 three times, id's 1 and 2 twice, and 3 and 4 once.</p>
  
  <p>As the lenght of the <code>IN</code> arguments, as well as the duplicate count (once, twice, three times, etc.), will be arbitrary I don't want to rely on <code>UNION</code> or <code>JOIN</code>. Is something like this possible otherwise?</p>