First of all. Happy new year everyone! This is my first post for the year 2014, and I would like to share a useful MySQL snippet wherein you can delete a series of comments based from an author’s IP. We all know for a fact that akismet can’t block all spam comments. My blog itself has a lot of spam comments lately, and I’ve been having a hard time delete it one by one.