Scott:
I see that you interpreted the original question differently than I did.
It sounded to me as if he was observing results coming out in seemingly
random order, and was wondering why they weren't coming out in insertion
order, but I can see that there was more than one reasonable guess as to
what he could have meant. Would you like to clarify the intent of the
question, Hunter?
On Tue, 5 Oct 1999, Scott Hess wrote:
> 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.
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread15230@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
--
Bob Kline
mailto:bkline@stripped
http://www.rksystems.com
