AW: Selecting rows at random

2004-03-29 Thread B. Fongo
: 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

Re: Selecting rows at random

2004-03-29 Thread Alec . Cawley
"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

Selecting rows at random

2004-03-29 Thread B. Fongo
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