# How write between query in rails

**URL:** <https://www.ruby-forum.com/t/how-write-between-query-in-rails/147477>\
**Category:** Rails\
**Created:** [September 2, 2008, 9:50am UTC](https://www.ruby-forum.com/t/how-write-between-query-in-rails/147477 "2008-09-02T09:50:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [September 2, 2008, 9:50am UTC](https://www.ruby-forum.com/t/how-write-between-query-in-rails/147477/1 "2008-09-02T09:50:02Z")

</div>

I am trying something like this i want result which is between ? and ?  
with one condition but query gives me sql syntax exception.

Group.find\_by\_sql([“select \* from groups where lft BETWEEN (?) and (?)  
and in\_directory=?”,self.lft,self.rgt, 1])

```
how i solve it.
```

---

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [September 2, 2008, 9:53am UTC](https://www.ruby-forum.com/t/how-write-between-query-in-rails/147477/2 "2008-09-02T09:53:49Z")

</div>

On Sep 2, 8:50 am, Sunny B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> I am trying something like this i want result which is between ? and ?  
> with one condition but query gives me sql syntax exception.

You don’t need the () with between.

Fred

PS find\_by\_sql is unnecessary here.

---

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [September 2, 2008, 9:55am UTC](https://www.ruby-forum.com/t/how-write-between-query-in-rails/147477/3 "2008-09-02T09:55:00Z")

</div>

:o

group = Group.find(:all,:conditions =\> ['lft BETWEEN ? and ? and  
in\_directory= ? ',self.lft,self.right,1])

hope this might be ur looking

On Tue, Sep 2, 2008 at 1:20 PM, Sunny B. \<