Search code examples
ruby-on-railsnamed-scopesearchlogic

Finding the union of multiple LIKE searches with searchlogic or named_scopes?

Given a delimited string of unknown length e.g. 'peanut,banana' or 'bacon,eggs,toast,arugula', I want to use named_scope or searchlogic in my rails 2.3.9 app to end up with a SQL statement like SELECT * FROM foods WHERE (name LIKE 'peanut') OR (name LIKE 'banana'). Ideas?

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

    from the searchlogic readme