+5 votes
1.4k views
in Home by (2.0k points)

How to delete pending comments massively in WordPress

1 Answer

+6 votes
by (18.3k points)
For administrators of sites with lots of activity, the built-in mass actions WordPress panel function is not enough. Because list an amount from 10 to 20 comments per page and sometimes have hundreds or thousands waiting. 
 
This is the situation that I play live recently, when they had more than 3,000 pending comments, which were content and months and years ago. So I had to go directly to the database. Which you can do via console or via PhpMyAdmin always friendly. 
 
Once you connect to the database by any of these options, you must run the following command line: 
 
DELETE FROM wp_comments WHERE comment_approved = "0" 
 
This means that you delete all comments from the wp_comments table and they are in the state of unapproved or pending or equal to zero
by
And also you can use WP-Optimize plugin
Ask a Question
Welcome to WikiTechSolutions where you can ask questions and receive answers from other members of the community.

You can ask a question without registration.

Categories

...