编写命名范围的更好方法？

Question

这个命名范围工作正常。

named_scope :search, lambda {|search_txt|
      {
        :conditions => ["field1 like ? or field2 like ? or field3 like ?","#{search_txt}%","#{search_txt}%","#{search_txt}%"]
      }
  }

而不是在条件中写三次search_txt。我可以通过在条件中仅传递一次 search_txt 来处理相同的场景吗？

像

named_scope :search, lambda {|search_txt|
      {
        :conditions => ["field1 like ? or field2 like ? or field3 like ?","#{search_txt}%"]
      }

}

Answer 1

我不知道这是否适用于某个范围，但还有另一种编写条件的方法：

MyModel.all(:conditions=>['field_1 LIKE :q OR field_2 LIKE :q OR field_3 LIKE :q', {:q=> 'search_txt'}])

Answer 2

这应该有效：

named_scope :search, lambda {|search_txt|
  {
    :conditions => ["field1 like :q or field2 like :q or field3 like :q",{:q => "#{search_txt}%"}]
  }

}