Sure....
I have a list of songs in a database that I use to build a radio playlist.
Currently they come out in insertion order (or something close) when I use
'select * from audio_files'...
I would like them to come out in random order so I don't have to shuffle the
playlist externally... Just wondering if I could handle that in the DB
instead of doing it externally...
----- Original Message -----
From: "Bob Kline" <bkline@stripped>
To: "Scott Hess" <scott@stripped>
Cc: "Hunter Hillegas" <hunter@stripped>; <mysql@stripped>
Sent: Tuesday, October 05, 1999 4:42 PM
Subject: Re: Outputting Selects in Random Order
> 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
>
>
