Re: Outputting Selects in Random Order

[Scott Hess]

To answer the question, though, you could probably do something like
'select rand() as randorder, * FROM RECORDS ORDER BY randorder', and then
arrange to ignore the randorder column.

Later,
scott

----- Original Message -----
From: Bob Kline <bkline@stripped>
To: Hunter Hillegas <hunter@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, October 05, 1999 2:29 PM
Subject: Re: Outputting Selects in Random Order


> On Tue, 5 Oct 1999, Hunter Hillegas wrote:
>
> > Is there any way from something like 'SELECT * FROM RECORDS' would
output
> > the results in a random order, not by insertion order?
> >
>
> SQL does not guarantee anything about the order of retrieval of rows in
> the absence of an ORDER BY ... clause.