rails 3 not nil

I'm trying to select all records that are not null from m开发者_Go百科y table using where method

MyModel.where(:some_id => !nil) 

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

---

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))

---

Use a string rather than a hash

MyModel.where("some_id is not null")

---

You can use:

MyModel.where("some_id IS NOT NULL")