INSERT INTO Destination SELECT Col1, Col2, Col3 FROM Source WHERE Col1 = 'example'
To copy a table and all it's data (not including primary keys, indexes, etc.):
SELECT * INTO Destination FROM Source