title: MySQL query (mixing an insert with select)
body: <p>I have a bunch of rows in a table with columns <code>a</code>, <code>b</code>, <code>c</code>. I'd like to be able to SELECT all rows where say a = 1, and reinsert them with a = 2. Essentially keeping all the rows where column a exist as is, and having a new batch of rows having as a = 2. What's the best query to establish such a multi-INSERT query? This is all happening in the same table. I don't mind using a temporary one if it's required.</p>