All New Phawville

How to Mass Delete Pending Comments in WordPress

Posted: 22 Mar 2011 05:21 AM PDT

How to Mass Delete Pending Comments in WordPress. There are 2 practical ways. One for the technically inclined and one for non-tech savvy users who simply want to get rid of thousands of spam pending comments in 1 go. Let us check out both solutions.

For the general user => How to Mass Delete Pending Comments in WordPress using a Plugin

It’s as simple as that. Here are the steps:

Go to your WP dashboard.
Click on “Add New” under Plugins and enter “WP Optimize” in the search box.
Install the WP-Optimize plugin and you’re all set!

Just play around with the plugin and you should be able to find your way around and delete all those pesky spam comments.

For the techie people => How to Mass Delete Pending Comments in WordPress via PHPMyAdmin

Taking this route has its advantages however small. One advantage is less overhead during WP loading but which has very minimal to no visual effect on users. But then again it’s your choice Here’s what you have to do:

Enter your CPanel and click on PHPMyAdmin
Select the database of your WP installation
Click on the SQL tab
Enter this code inside the SQL textbox:

DELETE FROM wp_comments WHERE comment_approved = ’0′

That’s it folks! Thanks for reading.

Horoscop

marți, 22 martie 2011