title: copying mysql rows within single table
body: <p>I have a mySQL database and am looking to update some rows with new values, but leave the originals intact.</p>
  
  <p>For example:  Within the site_files table, there is a 'site_id' column.  I have a bunch of rows where <code>site_id' = 981</code> but I want to change that to <code>site_id' = 2016</code> (and leave the original rows in <code>981</code>.</p>
  
  <p>I hope that makes sense.  I know it would be a simple matter to use the UPDATE statement, but I want to leave the rows that read 981 as well.</p>
  
  <p>Thanks in advance for any ideas.</p>