Delete all comments from Wordpress
I recently ran into the need to delete all the comments from my wordpress site. I had 11,000 comments submitted and the majority of them were spam. Here is a quick and simple way to delete all the comments from wordpress and reset the comment count on each post.
If you do not know what you are doing in regards to sql or the wordpress database I suggest you do not do this. I do not know any repercussions this might cause and haven’t tested it very much other than just deleting comments. So use this at your own risk.
Open your SQL environment and follow these two steps.
1)Run the delete query on the wp_comments table – “delete from wp_comments”.
2)Run the update query to reset your post comment count to 0 – “update wp_posts set comment_count = 0″;
Done
