_lallous wrote: > > Hello! > > Is there is anyway to copy from a table to another but by applying a filter? > > Example: > > SELECT * FROM table1 WHERE (condition) > INSERT INTO table2 (the results of the last query)
Just try this one: INSERT INTO table2 SELECT * FROM table1 WHERE (condition) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]