SQL code to change all pending comments to spam:
UPDATE `wp_comments` SET `comment_approved`='spam' WHERE `comment_approved` = 0;
If you’re not using Akismet, and you’ve let your pending, most likely “spam” comments, pile-up; the above SQL code will help convert all pending comments to spam.
So comments like:
What an insightful idea has been written here. Truly sharing this will my friends website for trackback linkjuice ranking will be an amazing thank-you!!!
Will never see the light of day. 😉