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: 388
random
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