Random selections from database
Moderator: General Moderators
Random selections from database
What is the easiest and safest way to pull 5 random items from my database. I am thinking the rand function can be used in some way, but I am not sure how safe etc this type of action will be? Thanks for any advice. 
Re: Random selections from database
"ORDER BY rand LIMIT 5" I'd say. It's certainly the easiest.
Re: Random selections from database
That is where I was headed but just wanted to make sure I wasn't missing anything. Thanks.