3 21:36
To: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: Hmm looks like this query works
I think your query will just return the first 10 values in the table sorted
in random order due to how MySQL handles queries that use ORDER BY and
LIMIT:
[from mysql documentation]
If you use LI
Try this instead...
SELECT val_column, 0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit
10;
Cheers,
A
-Original Message-
From: Eric Wagner [mailto:[EMAIL PROTECTED]
Sent: Tuesday 10 June 2003 21:36
To: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: Hmm looks like
I think your query will just return the first 10 values in the table sorted in random
order due to how MySQL handles queries that use ORDER BY and LIMIT:
[from mysql documentation]
If you use LIMIT # with ORDER BY, MySQL will end the sorting as soon as it has found
the first # lines instead of s
hieve the same result with 1 row.
-->-Original Message-
-->From: Becoming Digital [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, June 10, 2003 11:33 AM
-->To: [EMAIL PROTECTED]
-->Subject: Re: Hmm looks like this query works
-->
-->What's your end goal, and for what
What's your end goal, and for what do you need/desire a "weighted random?" Your
objective will determine if this is actually of use or if it simply appears to
be.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTE
