# String problem

**URL:** <https://www.ruby-forum.com/t/string-problem/153992>\
**Category:** Ruby\
**Created:** [November 24, 2008, 12:30pm UTC](https://www.ruby-forum.com/t/string-problem/153992 "2008-11-24T12:30:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [November 24, 2008, 12:30pm UTC](https://www.ruby-forum.com/t/string-problem/153992/1 "2008-11-24T12:30:42Z")

</div>

Hi How to find the resut by passing string as parameters in clause of  
mysql query

For example  
arr = [‘t’,‘a’]  
@user = User.find(:all,:conditions=\>[“firstname IN(#{arr.join(’,’)})”])  
it is executing like  
select \* from users where firstname IN(‘t,a’)  
it returns 0 rows

Plz reply if anybody knows solution

---

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [November 24, 2008, 2:38pm UTC](https://www.ruby-forum.com/t/string-problem/153992/2 "2008-11-24T14:38:48Z")

</div>

Hi –

On Mon, 24 Nov 2008, Ganesh G. wrote:

> Hi How to find the resut by passing string as parameters in clause of  
> mysql query
> 
> For example  
> arr = [‘t’,‘a’]  
> @user = User.find(:all,:conditions=\>[“firstname IN(#{arr.join(’,’)})”])  
> it is executing like  
> select \* from users where firstname IN(‘t,a’)  
> it returns 0 rows

You’ll probably get more responses to ActiveRecord questions on the  
Rails mailing lists. Meanwhile:

:conditions =\> [“firstname IN (?)”, arr]

David

---

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [November 24, 2008, 2:46pm UTC](https://www.ruby-forum.com/t/string-problem/153992/3 "2008-11-24T14:46:27Z")

</div>

Ganesh G. wrote:

> Hi How to find the resut by passing string as parameters in clause of  
> mysql query
> 
> For example  
> arr = [‘t’,‘a’]  
> @user = User.find(:all,:conditions=\>[“firstname IN(#{arr.join(‘,’)})”])

Docs: [http://apidock.com/rails/ActiveRecord/Base/find/class](http://apidock.com/rails/ActiveRecord/Base/find/class)

test666\> arr = %w(a b)  
=\> [“a”, “b”]  
test666\> User.find(:all, :conditions =\> { :firstname =\> arr} )  
User Load (26.0ms) SELECT \* FROM `users` WHERE (`users`.`firstname`  
IN (‘a’,‘b’))