Batch approve comments

Akismet went crazy and sent several hundred comments to spam. Right now, I have to manually mark each comment as "Not Spam" and then manually move all of them from Pending to Approved. Any way to do this in a more efficient way?

Topic akismet comments spam Wordpress

Category Web

1
answered at

You can use this SQL query to approve all spam comments:

UPDATE wp_comments SET comment_approved = 1 WHERE comment_approved = 'spam';

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.