title: INSERT INTO SELECT - Change a value
body: <p>How would I change a value of a column when using the <a href="https://www.w3schools.com/sql/sql_insert_into_select.asp" rel="noreferrer">INSERT INTO SELECT</a> which copies data from one table and inserts it into another table. See example (pic below)</p>
  <p>I'm trying to copy data from one (main) table to another table but update a value on 2nd table.</p>
  <p><a href="https://i.stack.imgur.com/oACEP.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/oACEP.jpg" alt="enter image description here" /></a></p>
  <p><strong>Code:</strong></p>
  <pre><code>INSERT INTO table2 SELECT * FROM table1 WHERE volume = 'Story of a Girl
  </code></pre>