Reputation: 913

rails 3 not nil

I'm trying to select all records that are not null from my table using where method

MyModel.where(:some_id => !nil)

but it doesn't work, is there any other solution to do this?

Upvotes: 8

Answers (3)

Reputation: 13675

You can do it using the Arel syntax (which has the bonus of being database independent):

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

Upvotes: 12

Reputation: 44982

Use a string rather than a hash

MyModel.where("some_id is not null")

Upvotes: 7

Reputation: 10422

You can use:

MyModel.where("some_id IS NOT NULL")

Upvotes: 2