title: MySQL table -> Can you return the same row multiple times, in the same query?
body: <pre><code>SELECT * FROM menu WHERE item_id = 1 OR item_id = 2 OR item_id = 3;
  </code></pre>
  
  <p>The above statement returns 3 rows.
  But the statement below only returns 2 rows.</p>
  
  <pre><code>SELECT * FROM menu WHERE item_id = 1 OR item_id = 1 OR item_id = 2;
  </code></pre>
  
  <p>And I understand why like, but is there a way to force item_id 1 to be returned twice???</p>
  
  <p>Example of what I want to be returned:</p>
  
  <blockquote>
    <p>id -> 1 Chips €2.50<br>
    id -> 1 Chips €2.50<br>
    id -> 2 Coke €1.60<br>
    --------------------<br>
    Total €6.60<br></p>
  </blockquote>