From a8d1412a3227ac3d14a40f0e62c9cd83b515ff95 Mon Sep 17 00:00:00 2001 From: Robin Dupret Date: Fri, 26 Jul 2013 15:11:58 +0200 Subject: Add a SQL example for `not` [ci skip] To share a certain logic across other examples, let's add a sample SQL code generated by the given Ruby code --- guides/source/active_record_querying.md | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'guides/source') diff --git a/guides/source/active_record_querying.md b/guides/source/active_record_querying.md index 0592821a14..9252a248b2 100644 --- a/guides/source/active_record_querying.md +++ b/guides/source/active_record_querying.md @@ -514,7 +514,13 @@ SELECT * FROM clients WHERE (clients.orders_count IN (1,3,5)) Post.where.not(author: author) ``` -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 code like this: + +```sql +SELECT * FROM posts WHERE (author_id != 1) +``` Ordering -------- -- cgit v1.2.3