method
where

v3.0.9 -
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

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

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)

0 thanks
usage examples
For detailed usage examples of where see “Conditions” under ActiveRecord::Base.