INSERT INTO SELECT - Change a value

Question

How would I change a value of a column when using the INSERT INTO SELECT which copies data from one table and inserts it into another table. See example (pic below)

I'm trying to copy data from one (main) table to another table but update a value on 2nd table.

Code:

INSERT INTO table2 SELECT * FROM table1 WHERE volume = 'Story of a Girl

Answer 1

INSERT INTO table2 (username, volume, name, image, content, cssanimate) 
    SELECT 'tim', volume, name, image, content, cssanimate 
    FROM table1 where volume='Story of a Girl';

If you list the columns you want to insert, you can replace columns with custom values.

You can get more complex too:

INSERT INTO table2 (username, volume, name, image, content, cssanimate) 
    SELECT 
        CASE 
            WHEN 'admin' THEN 'tim' 
            ELSE username 
        END CASE, 
        volume, name, image, content, cssanimate 
    FROM table1;

Answer 2

You can also modify columns at insert by using

INSERT INTO ...() SELECT ...REPLACE(fieldname, 'somestring','anotherstring') ...

Or even use a subquery

INSERT INTO ...() SELECT ...(SELECT id FROM tableName WHERE somefield = 'asd')...