diff options
author | Richard Schneeman <richard.schneeman@gmail.com> | 2016-04-21 17:14:10 -0500 |
---|---|---|
committer | Richard Schneeman <richard.schneeman@gmail.com> | 2016-04-21 17:14:10 -0500 |
commit | 2700a1aa43201a1d4cfbe4a8141291ef4b7e7653 (patch) | |
tree | b59f34e419746fc4644f3556887185c1b071572a | |
parent | f0a2edc7fc0874b98ab6d4dbfaadc1832451c742 (diff) | |
parent | e1a31f51f4a647d1b7c98cbc84b00784d7ef214b (diff) | |
download | rails-2700a1aa43201a1d4cfbe4a8141291ef4b7e7653.tar.gz rails-2700a1aa43201a1d4cfbe4a8141291ef4b7e7653.tar.bz2 rails-2700a1aa43201a1d4cfbe4a8141291ef4b7e7653.zip |
Merge pull request #24681 from tcopeland/not_example_can_demonstrate_inequality
Combine inequality and equality and add SQL examples [ci skip]
-rw-r--r-- | guides/source/active_record_querying.md | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/guides/source/active_record_querying.md b/guides/source/active_record_querying.md index e9f6275e55..9a13e3bda7 100644 --- a/guides/source/active_record_querying.md +++ b/guides/source/active_record_querying.md @@ -472,6 +472,12 @@ NOTE: Only equality, range and subset checking are possible with Hash conditions Client.where(locked: true) ``` +This will generate SQL like this: + +```sql +SELECT * FROM clients WHERE (clients.locked = 1) +``` + The field name can also be a string: ```ruby @@ -517,13 +523,17 @@ SELECT * FROM clients WHERE (clients.orders_count IN (1,3,5)) ### NOT Conditions -`NOT` SQL queries can be built by `where.not`. +`NOT` SQL queries can be built by `where.not`: ```ruby -Article.where.not(author: author) +Client.where.not(locked: true) ``` -In other words, this query can be generated by calling `where` with no argument, then immediately chain with `not` passing `where` conditions. +In other words, this query can be generated by calling `where` with no argument, then immediately chain with `not` passing `where` conditions. This will generate SQL like this: + +```sql +SELECT * FROM clients WHERE (clients.locked != 1) +``` Ordering -------- |