: Montag, 29. März 2004 14:59
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] Mysql. Com
Betreff: Re: Selecting rows at random
"B. Fongo" <[EMAIL PROTECTED]> wrote on 29/03/2004 13:54:54:
> Does MySQL provide a way of selecting a limited number of rows at
> random? From a query tha
"B. Fongo" <[EMAIL PROTECTED]> wrote on 29/03/2004 13:54:54:
> Does MySQL provide a way of selecting a limited number of rows at
> random? From a query that might return several rows, I want MySQL to
> return six rows at random at each time.
>
> For instance:
>
> Select * from [table] wher
Does MySQL provide a way of selecting a limited number of rows at
random? From a query that might return several rows, I want MySQL to
return six rows at random at each time.
For instance:
Select * from [table] where [condition];
200 rows (0.0 sec)
Now - I need 6 rows at random.
Than