[eluser]JHackamack[/eluser]
There is a MySQL command:
Code:
INSERT INTO smf_members (ID_MEMBER, memberName, emailAddress, passwd, dateRegistered, lastLogin ) SELECT id, name, email, password, creationtime, lastClickTime FROM classifieds_classifiedsuser WHERE COL1=COL1
Then you would do a separate delete command using your where clauses.