My evening, in one MySQL log
mysql> delete from mt_comment where comment_author like ‘%viagra%’;
Query OK, 1272 rows affected (1.04 sec)
mysql> delete from mt_comment where comment_author like ‘%adipex%’;
Query OK, 1113 rows affected (0.48 sec)
mysql> delete from mt_comment where comment_author like ‘%soma%’;
Query OK, 397 rows affected (0.19 sec)
mysql> delete from mt_comment where comment_author like ‘%valium%’;
Query OK, 106 rows affected (0.07 sec)
mysql> delete from mt_comment where comment_author like ‘%xanax%’;
Query OK, 190 rows affected (0.11 sec)
mysql> delete from mt_comment where comment_author like ‘%tramadol%’;
Query OK, 2573 rows affected (1.05 sec)
mysql> delete from mt_comment where comment_author like ‘%phentermine%’;
Query OK, 1632 rows affected (1.23 sec)
I really, really hate comment spammers.