Rails .where multiple values, one not nil

Question

This Code pulls records where foobar is Nil

Model.where(user_id: 14, foobar: nil)

How can I use the same Syntax and get NOT nil?

Something like:

Model.where(user_id: 14, foobar: !nil)

Answer 1

Rails 4:

Model.where(user_id: 14).where().not(foobar: nil)

Rails 3 - Rails where condition using NOT NULL

Answer 2

Model.where(user_id: 14).where("foobar IS NOT NULL")

Model.where("user_id = ? AND foobar IS NOT ?", 14, nil)