Random retrieveal from database

Rails
#1

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

–
Subashini kumar

#2

Subashini K. wrote:

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

Use RAND() function in mysql query…
select * from TABLE_NAME order by RAND() limit N

#3

Brijesh S. wrote:

Subashini K. wrote:

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

Use RAND() function in mysql query…
select * from TABLE_NAME order by RAND() limit N

Yeah !! cool!!! thanks a lot!!!