+------------+----------------+
| comment_ID | comment_author |
+------------+----------------+
| 22601 | Jack |
+------------+----------------+
1 row in set (0.01 sec)
mysql>
mysql> SELECT comment_ID, comment_author FROM wp_comments WHERE comment_post_ID=802 AND comment_type='' AND comment_author!='Ben' ORDER BY RAND() LIMIT 1;
+------------+----------------+
| comment_ID | comment_author |
+------------+----------------+
| 22587 | kel |
+------------+----------------+
1 row in set (0.00 sec)
Holy smokes! I won!?! Thanks Ben (and the randomness of MySQL)
November 1, 2009
congratulations to the winners, hope to have better luck in future contests
November 7, 2009