List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:October 5 1999 10:42pm
Subject:Re: Outputting Selects in Random Order
View as plain text  
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
Thread
A question about indexesMoz5 Oct
  • Re: A question about indexesBob Kline5 Oct
    • Outputting Selects in Random OrderHunter Hillegas5 Oct
      • Re: Outputting Selects in Random OrderThimble Smith6 Oct
      • Re: Outputting Selects in Random OrderBob Kline6 Oct
        • Re: Outputting Selects in Random OrderScott Hess6 Oct
          • Re: Outputting Selects in Random OrderThimble Smith6 Oct
          • Re: Outputting Selects in Random OrderBob Kline6 Oct
            • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
              • Re: Outputting Selects in Random OrderBob Kline6 Oct
                • Re: Outputting Selects in Random OrderMartin Ramsch7 Oct
    • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
Re: A question about indexesMark Papadakis5 Oct
  • Re: A question about indexesBob Kline6 Oct