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…

 

Solution:

 

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

 

http://www.blogopreneur.com/2009/04/08/mass-delete-pending-comments-from-wordpress/

 

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;

Bye

… you have no knowledge with worpress so used bloggerbuilder

Tags: ,

Leave a Comment