INSERT INTO newTablename SELECT field1, field2, field3 FROM oldTablename WHERE field1 > 100