Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Is there a good way of retrieving entries randomly from a database (MySQL perhaps)?

by epoptai (Curate)
on Jan 03, 2004 at 15:55 UTC ( #318517=note: print w/ replies, xml ) Need Help??


in reply to Is there a good way of retrieving entries randomly from a database (MySQL perhaps)?

You can select any number of random rows by limiting the results of your query:

SELECT question, answer FROM table ORDER BY RAND() LIMIT 1
It'll be much faster and more efficient than pushing all the results into an array and dumping them into a temporary table. That seems like too much work for the task you described, unless there's a good reason for the temp table.

--
perl -MO=Deparse -e"u j t S n a t o e h r , e p l r a h k c r e"


Comment on Re: Is there a good way of retrieving entries randomly from a database (MySQL perhaps)?
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://318517]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (17)
As of 2015-07-02 12:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (36 votes), past polls