How to mass delete Guest posts as comments on articles

[socceronly]

Not sure how / why but Guest posting was turned on for a while. 

Is there any way to delete Guest posts that on Pages Articles that were not stored in a Forum?

 

[socceronly]

Is there a way to simply delete all comments from a Database.   

It must in the thousands of posts, can't delete them manually.

Have to through out them all. 

[Faqole]

5 hours ago, socceronly said:

Is there a way to simply delete all comments from a Database.   

It must in the thousands of posts, can't delete them manually.

Have to through out them all. 

To delete all the posts made by guests in your forum run this sql query.

DELETE FROM `forums_posts` WHERE author_id = 0 AND new_topic = 0;

But first make a backup of the forums_table table. And if you are using a prefix for your tables, add it to the table name in the above query when you run it.