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. Thanks
- Re: Selecting rows at random B. Fongo
- Re: Selecting rows at random Alec . Cawley