How do I test for non-null in Ruby::Sequel? How do I test for non-null in Ruby::Sequel? ruby ruby

How do I test for non-null in Ruby::Sequel?


You can use exclude instead of where.

User.select(...).exclude(name: nil)


You can do this:

User.select(...).where('name IS NOT NULL')


The answer you seek is .where(Sequel.~(name: nil))

Read more here: https://github.com/jeremyevans/sequel/blob/master/doc/sql.rdoc