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
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 fictitious persons with id numbers
(primary key) ranging sequentially from 2 to 378. When I ran these
queries below, I was e