What rails console command can be used to query all the users whom has a home_state value in a table?

Question

I need a rails command that can query all the users who has a value in home_state. I have tried to use:

User.where('home_state')

but couldn't retrieve any information from it.

Does this answer your question? [Rails where condition using NOT NIL](https://stackoverflow.com/questions/4252349/rails-where-condition-using-not-nil) — dbugger, Jan 26 '22 at 01:12

score 1 · Answer 1 · answered Jan 26 '22 at 02:31

1

If you are looking for all users that do not have nil as a value for home_state, you can use User.where.not(home_state: nil)

answered Jan 26 '22 at 02:31

shadow-blake

score 1 · Answer 2 · answered Jan 26 '22 at 17:04

1

You can use User.where.not(home_state: nil)

answered Jan 26 '22 at 17:04

Prateek Vyas

2 Answers2