Prune all posts by usergroup query?

[Okiewan]

Need a little help. I need to delete all posts by the unregisterd/guest usergroup.
sql query please?

Thanks!

[AN-net]

DELETE FROM post WHERE userid=0;

edit:
i would also suggest running this just incase;):

DELETE FROM thread WHERE postuserid=0;

[g-force2k2]

I would probably do more than delete from the post and thread tables based upon those ids because there's also the thread rate, attachment, polls, etc to delete rows from, but just my opinion.

Cheers,
g-force2k2

[AN-net]

yeah i was going to say that also but i wasnt sure if he had enabled unregistered/not logged in to attach,vote, or rate threads. anyways, if you did allow them to just respond and ill whip up some queries to delete those also;)