frogrocker, first off I'd suggest you post questions like this to the MySQL & PHP Coding
forum instead of the general forum. You'll probably get your question answered faster.
Anyway, the page in the manual you're looking for is 188.8.131.52 - INSERT ... SELECT Syntax
. Essentially, all you do is tack a SELECT statement on the end of your INSERT statement. So if your tables have the exact same structure and you want to copy a row or several from table1 into table2, it'd look like this:
INSERT INTO table2 SELECT * FROM table1 WHERE ...
Of course, specify the usual WHERE statement at the end to match the rows you want to copy. Then, if you want to delete the row(s) from table1, use a plain old DELETE with the same WHERE clause.
That should do it. I'd be curious to know why you're moving rows between two identical tables, but that's your business.