RE: Include repeats in query

2005-04-18 Thread Martin Gallagher
t: Re: Include repeats in query "Martin Gallagher" <[EMAIL PROTECTED]> wrote on 04/16/2005 08:49:35 AM: > Hi, > > > > I have the following query: > > > > SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1 > > > > This r

Re: Include repeats in query

2005-04-18 Thread SGreen
"Martin Gallagher" <[EMAIL PROTECTED]> wrote on 04/16/2005 08:49:35 AM: > Hi, > > > > I have the following query: > > > > SELECT person FROM people WHERE ORDER BY RAND() * (1 / score) LIMIT 1 > > > > This returns a person randomly, but the chance of the person being selected > is increa