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.

This entry was posted in Rant. Bookmark the permalink.

2 Responses to My evening, in one MySQL log

  1. Andrew Ross says:

    Have you considered using Akismet (http://akismet.com/)?

  2. Berno says:

    What about another statement?
    mysql> delete from mt_comment where comment_author like ‘%penis%’;

Comments are closed.