Re: Outputting Selects in Random Order

[Thimble Smith]

At 15:32, 19991005, 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.

Please read the mailing list to make sure you understand how things
work in different versions of MySQL before using the above command -
it might not work the way you expect.

If you use the progressive-comp lists, you'll get lots of info if you
search for "random" or "orer by rand".

http://www.progressive-comp.com/Lists/?l=mysql&r=1&w=2

Tim