# Select \* from users where id in (2,5,8)

**URL:** <https://www.ruby-forum.com/t/select-from-users-where-id-in-2-5-8/137486>\
**Category:** Rails\
**Created:** [May 13, 2008, 4:56pm UTC](https://www.ruby-forum.com/t/select-from-users-where-id-in-2-5-8/137486 "2008-05-13T16:56:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![david](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@david](https://www.ruby-forum.com/u/david)\
**Post date:** [May 13, 2008, 4:56pm UTC](https://www.ruby-forum.com/t/select-from-users-where-id-in-2-5-8/137486/1 "2008-05-13T16:56:46Z")

</div>

Hello,

I’m trying to search for users in a set of ids:

select \* from users where id in (2,5,8)

Is there a “RoR” way to do the above query without having to resort  
to find\_by\_sql?

Or are there any plugins that allow this?

I am somewhat of a Ruby purist and don’t want to taint my code with  
SQL.

Thank you,  
David 🙂

---

<div class="post-metadata">

**Author:** ![david](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@david](https://www.ruby-forum.com/u/david)\
**Post date:** [May 13, 2008, 5:13pm UTC](https://www.ruby-forum.com/t/select-from-users-where-id-in-2-5-8/137486/2 "2008-05-13T17:13:31Z")

</div>

User.find(2, 5, 8)

The find method on an ActiveRecord model searches by ID, and it  
accepts one or many IDs.

Regards,  
Craig

---

<div class="post-metadata">

**Author:** ![david](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@david](https://www.ruby-forum.com/u/david)\
**Post date:** [May 16, 2008, 8:19am UTC](https://www.ruby-forum.com/t/select-from-users-where-id-in-2-5-8/137486/3 "2008-05-16T08:19:48Z")

</div>

wow. sweetness. thank you!

On May 13, 8:12 am, “Craig D.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)