<p>so here's how i handle moderation of comment spam. i go into <a href="http://www.phpmyadmin.net/">phpmyadmin</a>. export my comments table. then i cut out the top block of sql code.</p>

<blockquote>
  <code>
    DROP TABLE IF EXISTS `wp_comments`;<br>
    CREATE TABLE `wp_comments` (<br>
    `comment_ID` bigint(20) unsigned NOT NULL auto_increment,<br>
    `comment_post_ID` int(11) NOT NULL default '0',<br>
    `comment_` tinytext NOT NULL,<br>
    `comment__email` varchar(100) NOT NULL default '',<br>
    `comment__url` varchar(200) NOT NULL default '',<br>
    `comment__IP` varchar(100) NOT NULL default '',<br>
    `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',<br>
    `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',<br>
    `comment_content` text NOT NULL,<br>
    `comment_karma` int(11) NOT NULL default '0',<br>
    `comment_approved` enum('0','1','spam') NOT NULL default '1',<br>
    `user_id` int(11) NOT NULL default '0',<br>
    `comment_agent` varchar(255) NOT NULL default '',<br>
    `comment_type` varchar(20) NOT NULL default '',<br>
    `comment_parent` int(11) NOT NULL default '0',<br>
    PRIMARY KEY  (`comment_ID`),<br>
    KEY `comment_approved` (`comment_approved`),<br>
    KEY `comment_post_ID` (`comment_post_ID`)<br>
    ) TYPE=MyISAM AUTO_INCREMENT=1382 ;<br>
    <br>
    #<br>
    # Dumping data for table `wp_comments`<br>
    #<br>
  </code>
</blockquote>

<p>then i copy out the first block or so that are older already approved comments. then i do a kind of visual scrolling scan for non-spam. it may not be perfect. but until i get more comments or the wordpress admin dashboard makes it easier for me to delete hundreds of spam comments at a time, that's what i'm gonna do. so the chance of your hypothetical comment getting deleted is there, although its relatively small. if you do comment me for real and you're a real person, you could also <a href="mailto:veganstraightedge@gmail.com">email me</a> letting me know that your comment hasn't gotten thru.</p>