Today, I deleted all the previous comments (more than 200) that someone has made on my blog. I welcome on-topic, constructive comments, but please remember my comment policy. I just added an addendum to it:
Update, 7/20/2007: It should go without saying, but I also reserve the right to prune comments or delete all comments by someone that is being insulting, lowering the quality of the discourse, or otherwise being a jerk. 🙂 I reserve the right to delete comments for any reason, but I try to allow on-topic, constructive comments.
This time I saved the MySQL command I used to delete a user’s comments in WordPress:
delete from wp_comments where comment_author_email like “%domainname%” or comment_author_url like “%domainname%”;
That lets me delete all comments by unwelcome users more easily next time.