Re: Selecting non opposites

2004-03-22 Thread Tony Richardson
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 '%female%male%'

Re: Selecting non opposites

2004-03-22 Thread Dave Dash
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 enter

RE: Selecting non opposites

2004-03-22 Thread Diana Cristina Neves Soares
To select random values you could use: SELECT word FROM table ORDER BY rand() LIMIT 3 But the problem of not to select male and female together... Well, you could LIMIT your query to 4 and in your code, if one entry is one of male or female, you test the others not to be female or male (respec