title: How can i duplicate a bunch of records in mySQL
body: <p>How can I duplicate a bunch of records in mySQL?</p>
  
  <p>I have records like this:</p>
  
  <pre><code>ID - name - year
  -----------------
  1 jasmine - 1999
  2 peter   - 1999
  3 fleur   - 1999
  </code></pre>
  
  <p>How can I duplicate all the names with <code>WHERE year='1999'</code> to a new row with a new year?</p>
  
  <pre><code>ID - name - year
  -----------------
  1 jasmine - 1999
  2 peter   - 1999
  3 fleur   - 1999
  4 jasmine - 2000
  5 peter   - 2000
  6 fleur   - 2000
  </code></pre>
  
  <p>Any ideas?</p>