# Find method

**URL:** <https://www.ruby-forum.com/t/find-method/124651>\
**Category:** Rails\
**Created:** [December 31, 2007, 3:55pm UTC](https://www.ruby-forum.com/t/find-method/124651 "2007-12-31T15:55:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fishman2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fishman2001](https://www.ruby-forum.com/u/fishman2001)\
**Post date:** [December 31, 2007, 3:55pm UTC](https://www.ruby-forum.com/t/find-method/124651/1 "2007-12-31T15:55:02Z")

</div>

Hi, quick question may be simple to answer,  
how can I use the find method to get the last 20 entries in my mysql  
table:  
Sports.find(:(last 20 entries please), :conditions none)

cheers.fishman()

---

<div class="post-metadata">

**Author:** ![fishman2001](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/e9bcb4/32.png) [@fishman2001](https://www.ruby-forum.com/u/fishman2001)\
**Post date:** [December 31, 2007, 4:06pm UTC](https://www.ruby-forum.com/t/find-method/124651/2 "2007-12-31T16:06:34Z")

</div>

What i do in that case is reverse my order (use ‘id DESC’ for  
instance) with a limit (limit 20 in your case) and then reverse the  
array of results.

Comment.find(:all, :order =\> ‘id desc’, :limit =\> 20).reverse

or something similar.  
There may be a better way though.

chers,  
vanne