The method of deleting WordPress junk comments and pending comments in batches

This article is about how to delete WordPress spam comments and reviews in bulk. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Add the following code to the current theme functions.php:

Global $wpdb;$wpdb- > query ("DELETE FROM $wpdb- > comments WHERE comment_approved = 'parameter'")

Optional parameters:

Spam spam comments

0 comments to be reviewed

1 reviewed comments

For example, delete comments to be reviewed in batches, change the parameter parameter in the code to 0, delete spam comments to: spam

Tip: do not change the parameter to 1, or all passed normal comments will disappear and are irreversible. Remember!

Please delete the above code after use, there is no need to leave it in the topic.

Or install the plug-in to delete pending comments: Delete All Pending Comments

When enabled, you can find the delete actions page in the background comments menu.

Thank you for reading! So much for the bulk deletion of WordPress spam comments and comments to be reviewed. I hope the above content can be helpful to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.