How to delete all the comments in wordpress

Going back to an old blog, I found that there was more than 1700 comments pending, most of them spam since I didn’t put any good contents to this site.

In order to quickly delete all this comments, go to phpmyadmin and enter this SQL request:

DELETE FROM wp_comments WHERE comment_approved = 0

Don’t forget to save your database before doing it.

Posted in Wordpress

Leave a Reply