mass delete pending comments from wordpress – delete+comments+wordpress – delete comments wordpress.

mass delete pending comments from wordpress


I received many spam on my Blog regurlay,  The problem: i must delete good to! please put a new comment…




This is the link where i foound where delete all comments wordpress in one shut:


It’s safer to check beforehand how many comments will be deleted without first deleting it .


The following SQL will return the number of comments that will be deleted:


SELECT count(*) FROM wp_comments WHERE comment_approved=0;

The result should match the number of comments awaiting moderation.


Only then do you run the “delete” SQL:

DELETE FROM wp_comments WHERE comment_approved=0;


… you have no knowledge with worpress so used bloggerbuilder

Tags: ,

Leave a Comment