To get all posts with <code>publisher_id</code> equals to 10, 16, or 17, I do: <pre class="prettyprint"><code>Post.where(:publisher_id => [10, 16, 17]) </code></pre> How would I get all posts with <code>publisher_id</code> not equals to 10, 16, or 17 (i.e. all possible ids besides those three) ?

Just perform a : <pre class="prettyprint"><code>Post.where(["publisher_id NOT IN (?)", [10, 16, 17]]) </code></pre>

Rails 3: How to get all Posts which ids are not in a given list?

To get all posts with publisher_id equals to 10, 16, or 17, I do:

Post.where(:publisher_id => [10, 16, 17])

How would I get all posts with publisher_id not equals to 10, 16, or 17 (i.e. all possible ids besides those three) ?

877

asked May 20 '11 04:05

Just perform a :

Post.where(["publisher_id NOT IN (?)", [10, 16, 17]])

answered Jan 04 '23 06:01

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!