gistfile1.rb

named_scope :with_keywords, lambda {|q| 
    fields = %w(title information items.sku)
    tokens = q.split.collect {|c| "%#{c.downcase}%"}
    clause = (["(" + fields.map {|f| "#{f} LIKE ?" }.join(" OR ") + ")"] * tokens.size).join(" AND ")
    
    { :include => [:items], :conditions => [clause, *(tokens * fields.size).sort] }
}