How annoying! I’ve just spent about an hour trying to remove all the spam that I’ve discovered littering this blog. I didn’t realise that people were so low as to spam people’s blogs, but it seems to happen. At least, they did it to mine! There were at least two spam entries for online poker games on each and every post of mine. I spent the first 30 minutes deleting them each, one by one, before I realised that I could go into my database and run an SQL DELETE query on them. Once I’d worked out the right syntax
DELETE FROM comments WHERE email@example.com'; they were all deleted in less than 0.5 second. I feel quite proud of that, to be honest.
I’ve altered the way that comments can be left on this blog, however. All comments must now be accepted by me before they appear. (Confession: I accidentally deleted a comment left on the Waxman article. Sorry!)