computerproblems

October 06, 2007

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.

Posted by Ed at 03:14 PM | Comments (0)