How to Trash/Spam All Unreviewed Posts in WordPress (MySql Way)

If you ever got too many comments that you feel are undesired (usually spam, or all) and need to do so, here is an easy way to do this: log in to your MySql database and run the following statement:

DELETE FROM wp_comments WHERE comment_approved = 0

This will, as you can deduct, I take it, delete all comments that you have not reviewed.
As always, hope this helped someone!

This entry was posted in Quick Tips, WordPress and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *