I have a table of adjectives:

+--------+
| word   |
+--------+
| green  |
| ugly   |
| dark   |
| evil   |
| female |
| male   |
| drunk  |
+--------+


and I want to select three of them randomly, but I don't want female and male to accidentally appear together (since they are opposites).


I can't think of a query that can do that, although it seems like there should be something easy.

Any help out there?

Thanks ;)


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to