move a row

is there a simple query I can use to move a row from one table to another?

Depending on the database you are using you can use an INSERT/SELECT query. This will work in MySql for example:

Code:

---

INSERT INTO table (col1,col2,col3,col4)
    SELECT col1,col2,col3,col4 FROM othertable WHERE col1 > 5;

---