RE: Include repeats in query

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

"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

Include repeats in query

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 increased with a higher `score`. What I want to do is make a single query that will return 10 results