# How to do search with rails?

**URL:** <https://www.ruby-forum.com/t/how-to-do-search-with-rails/133271>\
**Category:** Rails\
**Created:** [March 29, 2008, 5:30pm UTC](https://www.ruby-forum.com/t/how-to-do-search-with-rails/133271 "2008-03-29T17:30:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SS\_SSSSS\_SSSSSSSSSS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ce7236/32.png) [@SS\_SSSSS\_SSSSSSSSSS](https://www.ruby-forum.com/u/SS_SSSSS_SSSSSSSSSS)\
**Post date:** [March 29, 2008, 5:30pm UTC](https://www.ruby-forum.com/t/how-to-do-search-with-rails/133271/1 "2008-03-29T17:30:34Z")

</div>

how to do search with rails?if i want search some thing in my database!

---

<div class="post-metadata">

**Author:** ![SS\_SSSSS\_SSSSSSSSSS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ce7236/32.png) [@SS\_SSSSS\_SSSSSSSSSS](https://www.ruby-forum.com/u/SS_SSSSS_SSSSSSSSSS)\
**Post date:** [March 29, 2008, 5:48pm UTC](https://www.ruby-forum.com/t/how-to-do-search-with-rails/133271/2 "2008-03-29T17:48:53Z")

</div>

User.find(:all) - will return everything in the database  
User.find\_by\_name(“John”) - will retun the first record with “John” in  
the name col.  
User.find\_all\_by\_name(“John”) - will return an array with all the  
records with the name “John”