Spam all pending WordPress comments SQL statment

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. 😉