Clear Unapproved WordPress Comments

  Print

Clear Unapproved WordPress Comments From The Database



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

d78eed727e4570bc3f777003ad1776395e837fb5?t=7b13ad93398d875195ea78fca5e1272c


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)

3e02b7ee6c938e2291e099910f04b887c3c60893?t=b7eb3fd5d0234e155e881581c58d79c4


Step 3 - Click on the SQL tab

0032ca23f41df8f4b7a96bb1f8a98be8a0fc5636?t=4c76495500ad18775fa7803d58198214


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

0c7c26a9d2451c072ca44b470cdc232822bd9ceb?t=86ee78105bf3362b6c13710ac75945b6


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

ef747921ee0b8529940ecc459f2f666d19d04223?t=73fdccf2f0077e6103a185f25334e619

Click OK to confirm the action

24027bc022a41994de3b48ef224710fca3e8c0f4?t=de023a7f4e0e2c75576aef25411e8e33


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.

b358655dc54fe2ea8d252b78b7dc9da9671e0f37?t=f82e057b9fcac6e594c1166b69c95d8b




Related Articles


  • Comments

Add Comment

Replying to