From: Kaspar Schiess <eule@...>
Date: 2009-09-23T15:22:27+09:00
Subject: Re: Random record retrieval from database

Hi, 

> How can i choose some "n" (n is gonna be fixed )records randomly from
> a mysql database table from our controller?

What I usually do is compute a column using a random function (mysql 
has one) and then order by that column. You can use LIMIT to only 
retrieve some results. 

This is going to be CPU/Disk intensive if your table is very large. 

kaspar