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. ;)