title: Generate duplicate rows in SELECT query (MySql)
body: <p>Is it possible in <code>SELECT * FROM</code> generate duplicate rows?</p>
  
  <p>In some rows, I have a filed called quantity. When quantity is more than 1, I would like to duplicate that record.</p>
  
  <pre><code>example
      item    quantity
      book        1
      phone       3
      pencil      1
  </code></pre>
  
  <hr>
  
  <p>what I would like to get in recordset is</p>
  
  <pre><code>book
  phone
  phone
  phone
  pencil
  </code></pre>
  
  <p>Is that possible?</p>