Xah Lee wrote:
> Thanks Tschau Christian. The proposed solution works.
> However, isn't there a proper method to get random rows? (instead of adding
> a 'random' column ad hoc to a table.)
> Does SQL/92 specify a way to select rows randomly?
< cut >
On the mysql TODO list "F.2 Things that have to be done sometime":
Allow sorting on RAND():
SELECT email,RAND() AS ran FROM info ORDER BY ran;
But this isn't standard SQL92.
SQL92 doesn't provide any syntax for 'random order'.
With SQL92 only, you have to generate the random values to fill the additional 'random'