Ganesh Ganesh 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

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'))

-- 
Posted via http://www.ruby-forum.com/.