Select from DB without some value

Question

I have my own rails app and I need to specify what I want to get from DB (pg). Ordinary, we do it like that: @posts = Post.all and I will get all the post in my Post Table.

In Post Table I have a categories, as a boolean: (photo, video, etc.) and when I want to select only posts witch response to photo category, we do it like that: @posts = Post.where(photo: true)

But what I need, is to select all posts without, for example, video. It have to look something like that: @posts = Post.all.without(video:true). How to make it happen?

UPDATED

And is there any possibility to block several values? I mean something like that Post.where.not(id: 1 && 2). I really don't know how it must look like. What i need - is to select all Posts without posts with ID 1 and 2.

Ursus · Accepted Answer · 2016-08-26 10:15:25Z

5

Try

@posts = Post.where.not(video: true)

answered Aug 26, 2016 at 10:15

Ursus

30.1k3 gold badges36 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bartłomiej Gładys · Accepted Answer · 2016-08-26 10:16:34Z

1

you can use .not, for example

@posts = Post.where.not(video:true)

answered Aug 26, 2016 at 10:16

Bartłomiej Gładys

4,6151 gold badge17 silver badges25 bronze badges

1 Comment

eweb Over a year ago

or @posts = Post.where(video: false)

eweb · Accepted Answer · 2016-08-27 12:12:59Z

1

You can pass an array of values: Post.where.not(id: [1, 2])

answered Aug 27, 2016 at 12:12

eweb

7487 silver badges11 bronze badges

Collectives™ on Stack Overflow

Select from DB without some value

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related