How can i choose some "n" (n is gonna be fixed )records randomly from a mysql database table from our controller? -- Subashini kumar -- Posted via http://www.ruby-forum.com/.
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/.
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 NYeah !! cool!!! thanks a lot!!! -- Posted via http://www.ruby-forum.com/.