INSERT INTO newTablename (SELECT field1, field2, field3 FROM oldTablename WHERE field1 > 100)
info at phpclasses dot org