The answers for [this question](https://stackoverflow.com/questions/149784/how-do-you-copy-a-record-in-a-sql-table-but-swap-out-the-unique-id-of-the-new-ro) almost answer mine, but not quite. How do I turn this:

```
col0  col1 col2
data0 a    foo
data1 b    foo
data2 c    fee
data3 d    fee

```

into this? (duplicating the `foo` rows only)

```
col0  col1 col2
data0 a    foo
data1 b    foo
data2 c    fee
data3 d    fee
data0 a    bar
data1 b    bar

```

Where `bar` is from the statement, not the data, and the original table has 2 new rows.