Do you get a lot of comments on your blogs and wonder if you have to delete them one at a time?

I did and on a couple of my blogs its been a huge issue – having all those pending comments and it filling up the database on my hosting account – but who in their right mind would want to sit there and delete even 10 at a time?

Not me.

So is there a way to do this quick?

You’ll need CPanel hosting access – because you need to find where your phpMyAdmin so you ca get to the wordpress database where your wordpress software is installed.

Once inside the phpMyAdmin area and where you have your wordpress database installed -

1. click on the SQL tab

2. enter into the text box

DELETE FROM wp_comments WHERE comment_approved = ’0′

3. click “go”

Then to make sure you did it right – log into the wordpress admin and all those pesky pending comments should now be gone.

If you have questions about this – I can make a video showing you how I did it for one of my blogs for anyone else who needs to see before they do.

And remember if in doubt make a database backup before you or anyone else attempts changes to this data.