ha HA!

DELETE
FROM `mt_comment`
WHERE comment_visible = 0

What does this mean? It means death to spammers, bots, and the shadowy evil-doers of the intertubes. It means "get rid of all my unpublished comment spam." It means freedom.

After some tinkering, I finally figured out the SQL command that would get rid of all the bad comments that have been cluttering up the back-end of this blog for years. This is what happened, and how long it took:

Deleted rows: 29244 (Query took 27.2919 sec)

I love/hate computers.