Most Efficient Way To Retrieve MYSQL data in random order PHP

Posted by Belgin Fish on Stack Overflow See other posts from Stack Overflow or by Belgin Fish
Published on 2010-04-02T02:48:15Z Indexed on 2010/04/02 2:53 UTC
Read the original article Hit count: 362

Filed under:

Hey, I have a query like so

SELECT * FROM table WHERE premium = 3

I'm just wondering how I can have it return a random order for the results!

i was told not to use ORDER BY RAND(); because of the amount of system resources it uses.

Thanks.

© Stack Overflow or respective owner

Related posts about random