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.