I came back from a lovely vacation visiting friends in Arizona to find over a thousand spam comments on my blogs, from several different I.P. addresses. Luckly, a few SQL statements along these lines
DELETE FROM `mt_comment` WHERE comment_url LIKE '%bestiality%' OR comment_url LIKE '%animal%'
DELETE FROM `mt_comment` WHERE comment_url LIKE '%insest%' OR comment_url LIKE '%incest%'
took care of the problem. (I have to give Michael credit for suggesting I try SQL instead of deleting the things one at a time. Oy!)DELETE FROM `mt_comment` WHERE comment_url LIKE '%insest%' OR comment_url LIKE '%incest%'
