ruby-on-rails - 用洗劫做一个手术室

Question

一个基本问题，但我在 project page 中找不到明确的内容或 wiki .我有以下代码:

field = "secre"
Position.search( {:description_cont => field, :code_cont => field}).result(:distinct => true).to_sql
 => "SELECT DISTINCT `positions`.* FROM `positions`  WHERE ((`positions`.`description` LIKE '%secre%' AND `positions`.`code` LIKE 0))"

但我的查询应该是这样的:

 => "SELECT DISTINCT `positions`.* FROM `positions`  WHERE ((`positions`.`description` LIKE '%secre%' OR `positions`.`code` LIKE 0))"

任何帮助，将不胜感激。提前致谢

Answer 1

请尝试以下操作:

Position.search( {:description_or_code_cont => field}).result(:distinct => true).to_sql