Rails 3 is not zero

Question

I am trying to select all records that are not null from my table using the method

MyModel.where(:some_id => !nil) 

but it does not work, is there any other solution for this?

Answer 1

Use a string, not a hash

 MyModel.where("some_id is not null") 

Answer 2

You can do this using Arel syntax (which has a database independent bonus):

 MyModel.where(MyModel.arel_table['some_id'].not_eq(nil)) 

Answer 3

You can use:

 MyModel.where("some_id IS NOT NULL")