/ Ruby on Rails
/
method

where

where(opts, *rest)
public

No documentation available.

# File activerecord/lib/active_record/relation/query_methods.rb, line 132
    def where(opts, *rest)
      return self if opts.blank?

      relation = clone
      relation.where_values += build_where(opts, rest)
      relation
    end

3Notes

Rails Guides

Ajedi32 · Aug 22, 2012

There is an excellent guide on the use of this method located here:

http://guides.rubyonrails.org/active_record_querying.html#conditions

IS NOT NULL or !=

sandyxu · Jun 26, 2013

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

usage examples

lkyrala · Dec 3, 2013

For detailed usage examples of where see "Conditions" under ActiveRecord::Base.