You know, I’d dearly love to get my hands on the scum-sucking vermin that continue to spew comment spam at my blog. 10 minutes, a small room and a cricket bat… that’s all I ask.
Failing that, I’ll just settle for doing a mass deletion of their comments every few days. It takes me all of two minutes, maybe, to log into the server and run the following in the MySQL client:
DELETE FROM wp_comments WHERE comment_approved = "0";
That’s it. I think WordPress 1.5 has a mass deletion option via the WP admin interface, or I’d take the ten minutes it requires to write a script to do it via the WP admin interface myself.
March 1, 2007 — Update: Obviously, WordPress features since this post have made this unnecessary, and I’m not even 100% sure if this would still work. If you still have WordPress spam problems, make sure you’re using Akismet and the Bad Behavior plugin. They work a treat.
