Thread: Delete ALL Comments from Wordpress

I noticed one of our Wordpress sites contained thousands of spam comments. These comments were all unapproved, so they were not published on the web site. Nevertheless, I decided to delete them.

It would take an hour to delete all of those comments with the Wordpress GUI front-end, so I went to MySQL for a quick fix.

SQL Command to Delete all Pending Comments In Wordpress:

Code:

delete from wp_comments WHERE comment_approved ="0";

SQL Command to Delete all Approved Comments in Wordpress:

Code:

delete from wp_comments WHERE comment_approved ="1";

SQL Command to Delete ALL Comments In Wordpress:

Code:

delete from wp_comments;

As per usual, be certain to back up your database before using MySQL commands directly.

Looks good, I didn't know we have a blog btw

one of our Wordpress sites

But I understand what you mean

Thanks for the post

Ahh... in this context, "our" meant "Free Internet Media."

Originally Posted by Will.Spencer

Ahh... in this context, "our" meant "Free Internet Media."

Yeah, that's why I added this to my comment:

But I understand what you mean

I didn't know it was related to FIM, but I knew it was related to you and your business

Nice! I think I've got a few blogs that need cleaning up