method
where
![Moderate documentation Importance_2](https://d2vfyqvduarcvs.cloudfront.net/images/importance_2.png?1349367920)
v3.1.0 -
Show latest stable
-
3 notes -
Class: ActiveRecord::QueryMethods
- 1.0.0
- 1.1.6
- 1.2.6
- 2.0.3
- 2.1.0
- 2.2.1
- 2.3.8
- 3.0.0 (0)
- 3.0.9 (0)
- 3.1.0 (0)
- 3.2.1 (0)
- 3.2.8 (0)
- 3.2.13 (0)
- 4.0.2 (38)
- 4.1.8 (0)
- 4.2.1 (0)
- 4.2.7 (0)
- 4.2.9 (0)
- 5.0.0.1 (0)
- 5.1.7 (0)
- 5.2.3 (0)
- 6.0.0 (0)
- 6.1.3.1 (0)
- 6.1.7.7 (0)
- 7.0.0 (0)
- 7.1.3.2 (5)
- 7.1.3.4 (0)
- What's this?
Register or
log in
to add new notes.
Ajedi32 -
August 22, 2012 - (>= v3.0.0)
sandyxu -
June 26, 2013 - (v3.0.0 - v3.2.13)
lkyrala -
December 3, 2013
![Default_avatar_30](https://www.gravatar.com/avatar/5c9d0ecbe3045579b72f96744c62735c?default=http://apidock.com/images/default_avatar_30.png&size=30)
0 thanks
Rails Guides
There is an excellent guide on the use of this method located here:
http://guides.rubyonrails.org/active_record_querying.html#conditions
![Default_avatar_30](https://www.gravatar.com/avatar/e6ff2eb8d3a16f08b9b770ffab185ec4?default=http://apidock.com/images/default_avatar_30.png&size=30)
0 thanks
IS NOT NULL or !=
where.not()
# SELECT `users`.* FROM `users` WHERE (`users`.`id` != 1) AND (`users`.`name` IS NOT NULL) User.where.not(id: 1).where.not(name: nil)
![Default_avatar_30](https://www.gravatar.com/avatar/1721d25deb9e4d538737402ad7d02c9e?default=http://apidock.com/images/default_avatar_30.png&size=30)
0 thanks
usage examples
For detailed usage examples of where see “Conditions” under ActiveRecord::Base.