使用searchlogic 或named_scopes 查找多个LIKE 搜索的并集？

Question

给定一个未知长度的分隔字符串，例如'peanut,banana'或'bacon,eggs,toast,arugula'，我想在我的rails 2.3中使用named_scope或searchlogic。 9 应用程序以 SQL 语句结束，例如 SELECT * FROM food WHERE (name LIKE 'peanut') OR (name LIKE 'banana')。有想法吗？

Answer 1

Food.name_like_any("peanut", "banana")
# it also accepts an array
Food.name_like_any(["bacon", "eggs", "toast", "arugula"])

来自 searchlogic 自述文件