WordPress - Clear Unapproved Comments

To make it easier to get in touch with us, from the 24th of March 2016 all support tickets will need to be submitted from your Crucial Control Panel.

How to Clear Unnaproved WordPress Comments From The Database

Step 1 - Log in to cPanel (click here for a guide) and click on phpMyAdmin



Step 2 - Click on the Database you want to clear comments from (if you have multiple databases, you'll need to find the name of the correct one. Click here for a guide on doing that)



Step 3 - Click on the SQL tab


Step 4 - Take note of the name of the comments table


Step 5 - Add in the bellow code. Make sure to replace wpov_comments with the name of your comments table. Click Go to start the clean up.

DELETE FROM wpov_comments WHERE comment_approved = 0


Click OK to confirm the action


Once it's done, you'll see a screen that looks like this. For larger databases, you may need to wait a few minutes before this completes.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk