INSERT INTO table (col1, col2, col3, col4) select :newCol1, col2, col3, col4 FROM table WHERE col1 = :oldCol1
Now I am not sure if the placeholders will work just like this, but the format of this query is what you should be after. Notice that we don’t include ‘VALUES’ clause and such.