How to check for non-null in Ruby :: Sequel?

Question

I want to do something like

User.select(...).where(:name != nil) 

not recording something like

 User.select(...).to_a.find_all {|user| user.name} 

I can choose null values, but not for non-empty ones. Is there a trick or Sequel external domain?

Answer 1

You can use exclude instead of where .

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

Answer 2

You can do it:

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