How to add condition "LIKE ? %something%" to the product title to this join

Question

Product.find(:all,
    :conditions => { :companies => { :malls => { :id => 1},:products => {:title => "nexus one"} }},
    :joins => [:company => :mall])

Answer 1

I found the solution, I think I have to take break,

Product.find(:all,:conditions => ['title LIKE ? and mall_id = ?', "%#{search}%",mall_id],
        :joins => [:company => :mall])