# Random retrieveal from database

**URL:** <https://www.ruby-forum.com/t/random-retrieveal-from-database/175972>\
**Category:** Rails\
**Created:** [September 23, 2009, 7:56am UTC](https://www.ruby-forum.com/t/random-retrieveal-from-database/175972 "2009-09-23T07:56:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![subashinikumar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/0ea827/32.png) [@subashinikumar](https://www.ruby-forum.com/u/subashinikumar)\
**Post date:** [September 23, 2009, 7:56am UTC](https://www.ruby-forum.com/t/random-retrieveal-from-database/175972/1 "2009-09-23T07:56:57Z")

</div>

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

–  
Subashini kumar

---

<div class="post-metadata">

**Author:** ![subashinikumar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/0ea827/32.png) [@subashinikumar](https://www.ruby-forum.com/u/subashinikumar)\
**Post date:** [September 23, 2009, 8:18am UTC](https://www.ruby-forum.com/t/random-retrieveal-from-database/175972/2 "2009-09-23T08:18:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![subashinikumar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/0ea827/32.png) [@subashinikumar](https://www.ruby-forum.com/u/subashinikumar)\
**Post date:** [September 23, 2009, 8:31am UTC](https://www.ruby-forum.com/t/random-retrieveal-from-database/175972/3 "2009-09-23T08:31:54Z")

</div>

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!!!