ROTECTED]
> Sent: Monday, April 30, 2007 2:42 PM
> To: MySQL
> Subject: RE: Research Subjects drawn randomly from databases
>
> id is an integer ...
>
> describe persons;
> ++---+--+-+---
> --+---+
> | Field | Type
0.674.8341
>
>
> > -Original Message-
> > From: John Kebbel [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, April 29, 2007 11:49 AM
> > To: MySQL
> > Subject: Re: Research Subjects drawn randomly from databases
> >
> > I rewrote my line using
From: John Kebbel [mailto:[EMAIL PROTECTED]
> Sent: Sunday, April 29, 2007 11:49 AM
> To: MySQL
> Subject: Re: Research Subjects drawn randomly from databases
>
> I rewrote my line using your suggestion ...
>
> select id,first,middle,last from persons order by rand() limit 10;
I rewrote my line using your suggestion ...
select id,first,middle,last from persons order by rand() limit 10;
and it worked perfectly. I'm still curious about why my original version
gave such cockeyed results, but I'll focus on the successful solution
and leave that unsolved problem for anoth
If might suggest:
SELECT * FROM BAR
ORDER BY RAND()
LIMIT 10
On 4/29/07, John Kebbel <[EMAIL PROTECTED]> wrote:
For possible educational research purposes, I was playing around with a
query that would randomly select people from a database. The database I
experiment with has a group of fictiti
://www.cyberbasin.com
915.688.0127
-Original Message-
From: Sumeet Chahal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 2:09 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Research
Hello,
My name is Sumeet Chahal and I work for
Hello,
My name is Sumeet Chahal and I work for Usability Sciences in Dallas, TX.
We will be conducting industry research for a large data modeling software
company. The results of this study will be used for product development and
marketing purposes. We are looking for people to participate
