Say I have a query that inserts using a select as such:

INSERT INTO courses name, location, gid SELECT (name, location, gid) FROM courses WHERE cid = $cid

Is it possible to only select "name,location" for the insert, and set gid to something else in the query?

Found my answer.

INSERT INTO courses (name, location, gid) SELECT name, location, $this->gid FROM courses WHERE cid = $cid