"Where" method with "not nil" checking

Question

How can I check if my variable is not nil when I use the "where" method ?

I tried these on a Product model that has a borrower_id field, but it didn't worked properly :

> Product.where("borrower_id.nil?")
> Product.where("borrower_id != nil")
> Product.where("borrower_id == !nil")

The only way I found was this one :

> Product.where("borrower_id > 0")

But it doesn't seem very clean...

score 1 · Answer 1 · answered May 21 '13 at 09:43

1

Try these:

> Product.where("borrower_id !=?", nil)
> Product.where("borrower_id !=?", "")

answered May 21 '13 at 09:43

rony36

score 1 · Accepted Answer · answered May 21 '13 at 09:44

1

Try

Product.where('borrower_id IS NOT NULL')

answered May 21 '13 at 09:44

2 Answers2