title: mysql select row then copy row and update values
body: <p>Is there a mysql syntax that can preform a select values from a table, then copy those values into the same table, but update a few columns of the copy?</p>
  
  <p>Table (<code>ticket</code>s), <code>id</code> is primary key, auto_increment:</p>
  
  <pre><code>id | name | start_date | end_date | value | active
  </code></pre>
  
  <ul>
  <li>Select a single row from tickets given a few values like <code>name</code>, <code>start_date</code>, <code>end_date</code> and <code>value</code></li>
  <li>Copy the row that matches the statement but update the value by <code>x</code></li>
  <li>Insert the copy with the update</li>
  </ul>