Query methods: Conditions

- [Instructor] We've seen how to perform…the basic find operations, but most times,…on their own, these are too simple to search…for records that match complex criteria.…Instead, we'll need to construct queries.…Let's start that by looking at conditions.…Conditions let you specify the criteria…that the data must meet to be part of the query results.…So we use the method where, and then tell it…what conditions it ought to meet.…So for example, Subject.where and then…I'm providing the hash with (:visible => true).…

This is going to look for subjects…where the visible column or attribute is equal to true.…We can express this condition in several different ways.…We can use a string, we can use an array,…or we can use a hash.…Let's look at each one.…With a string, you can just simply provide a string…that gets dropped into that where statement.…This would find all subjects where the name was Test…and visible was equal to true.…This is flexible because we get to issue raw SQL in here,…and it will drop it straight into our query.…