subject:"\[Rails\] Re\: Random retrieveal from database"

[Rails] Re: Random retrieveal from database

2009-09-23 Thread Brijesh Shah

Subashini Kumar 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 -- Posted via http://www.ruby-forum.com/.

[Rails] Re: Random retrieveal from database

2009-09-23 Thread Subashini Kumar

Brijesh Shah wrote: Subashini Kumar 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!!! -- Posted