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: 394

Filed under:

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.

Related posts about random

Text inside <p> shrinks on mobile devices while div does not [migrated]

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I asked this question on stack overflow, but didn't get any answers, so I'm trying here. Does anybody know whats happening here? I tested on opera, dolphin and the factory android browser. (although it seems now to be working on opera) The div doesn't change size, but the text somehow is shrunk… >>> More
Random Movement for multiple entities

as seen on Game Development - Search for 'Game Development'
I have this code for a arraylist of entities. All the entities use the same random and so all of them move in the same direction. How can I change it so it generates a new random number for each entity? public void moveFemale() { for(int i = 0; i < 1000; i++){ random = rand.nextInt(99); … >>> More
Python: Random is barely random at all?

as seen on Stack Overflow - Search for 'Stack Overflow'
I did this to test the randomness of randint: >>> from random import randint >>> >>> uniques = [] >>> for i in range(4500): # You can see I optimistic. ... x = randint(500, 5000) ... if x in uniques: ... raise Exception('We duped ' + str(x) + '… >>> More
Why is Random class isn't really random?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've read about it on a message board - Random class isn't really random. It is created with predictable fashion using a mathematical formula. Is it really true? If so, Random isn't really random?? >>> More
c++ generate a good random seed for psudo random number generators

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to generate a good random seed for a psudo-random number generator. I thought I'd get the expert's opinions. let me know if this is a bad way of doing it or if there are much better ways. #include <iostream> #include <cstdlib> #include <fstream> #include <ctime> unsigned… >>> More

Developer IT

Most Efficient Way To Retrieve MYSQL data in random order PHP - Developer IT

Most Efficient Way To Retrieve MYSQL data in random order PHP

random

Related posts about random

Text inside <p> shrinks on mobile devices while div does not [migrated]

Random Movement for multiple entities

Python: Random is barely random at all?

Why is Random class isn't really random?

c++ generate a good random seed for psudo random number generators

Categories cloud