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
(respectively). For shure, you
will always have 3 different values and you won't have male and female together
(pityfully ;-)
Diana Soares
-Original Message-
From: news on behalf of Dave Dash
Sent: Mon 3/22/2004 3:38 PM
To: [EMAIL PROTECTED]
Cc:
Subject:Selecting non
Yeah, I want to avoid code if possible, some ideas was marking
adjectives with a class tag, and doing a group by class so only one item
in any given class would appera
e.g. good and evil would have the same class or male and female would
have the same class.
this, however, requires me to
I'm a newbie but thought I'd try my hand and offer an extremely
inefficient query that seemed to work ...
select * from
word join
word as tw join
word as tm
where concat(word.wd, tw.wd, tm.wd) not like '%male%female%' and
concat(word.wd, tw.wd, tm.wd) not like