I have a large database of products and everyday I wish to run a script that moves rows with active = '1' into a new table and deletes the original row.

But I can't seem to find the appropriate Mysql command to accomplish the migration.

It would be great if someone could shed some light on the situation.

Thanks a lot