Approve all the pending comments in wordpress

We will use a Mysql query to approve all the comments in your wordpress database at once.

Login to Phpmyadmin
Select the wordpress’s database
Go to ‘SQL’ tab and put the following code.

UPDATE wp_comments SET comment_approved = 1;

Note: The comments in Trash and Spam categories would also be approved, so keep them clean before issuing the above command.

Suggested WordPress Plugins:

  • Hide-n-Disable-comment-url-field
  • Hide Comment Author Link
  • Minimum comment length
  • No Comment Links
  • Remove html comments
  • Short Comment Filter
  • WTC Comment Cleaner

Join the Conversation

1 Comment

  1. Is there piece of code I could use that would delete all comments that are less than 10 charachters?

Leave a comment

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