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 via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---