mysql> SELECT comment_ID, comment_author FROM wp_comments WHERE comment_post_ID=806 AND comment_type=” AND comment_author!=’Ben’ ORDER BY RAND() LIMIT 1;
+————+—————-+
| 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)
congratulations to the winners, hope to have better luck in future contests 🙂