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
instead of sorting the whole table
http://www.mysql.com/doc/en/LIMIT_optimisation.html
> -Original Message-
> From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 11:19 AM
> To: [EMAIL PROTECTED]
> Subject: Hmm looks like this query works
&
sorting the whole table
http://www.mysql.com/doc/en/LIMIT_optimisation.html
> -Original Message-
> From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 11:19 AM
> To: [EMAIL PROTECTED]
> Subject: Hmm looks like this query works
>
>
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
Pattishall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 14:19
Subject: Hmm looks like this query works
I have a question. If I wanted to sort randomly on a column weighted by
the value of the column will does this query work
SELECT val_column, val_column*0.
I have a question. If I wanted to sort randomly on a column weighted by
the value of the column will does this query work
SELECT val_column, val_column*0.1+RAND() as rand_col from TABLE ORDER BY
rand_col limit 10;
This should five me a random row weighted by the value of the column is
this corr
