How to do a search on two fields?

Question

Laravel

There is a User model. It has two fields first_name and last_name. When I enter a search query like "Yves" then I can find a user let's say first_name Ivan and last_name Ivanov. But how to make a request if Ivan Ivanov is entered? So far, it only comes to mind to split the string into two elements and sort through all possible options. maybe there is some more elegant solution?

Answer 1

foreach (explode(' ', $query) as $search) {
    $q->where(function($q) use ($search) {
        $q
            ->where('last_name', 'ilike', "%$search%")
            ->orWhere('first_name', 'ilike', "%$search%")

    });
}