Delete all spam comments from your wordpress blog

Those who has our own wordpress blog or we are managing any wordpress blog site, we face the unwanted comments to our posts. When the comments are around below hundreds, it is fine to remove them manually. But when the number is more than fifty thousands, it is not a good idea to start deleting them manually.

Here is now you can remove them easily.

1. Open phpmyadmin
2. Locate your wordpress blog site schema
3. Click on the SQL tab
4. Try the following sql command

delete from wp_comments where comment_approved = 0

All new comments which are not approved will be removed from all the posts.

Leave a Comment