arel-ish ishy Search.name!

gistfile1.rb

  def name!
    return unless name
    person = Person.arel_table
    family = Family.arel_table
    concat = Arel::Nodes::NamedFunction.new 'concat', [person[:first_name], ' ', person[:last_name]]
    
    where(concat.matches(like(name)).or(
      family[:name].matches(like(name)).or(
        person[:first_name].matches(like(name.split.first, :after)).and(
          person[:last_name].matches(like(name.split.last, :after))))))
  end