Laravel Search Query

Laravel search query with multiple conditions add simple “where” clauses to your search queries Example with Like Operator.

Contents

The database table stores firstname and lastname as separate fields. the following tables write a SQL query to find the First Name and Last Name.

Example 1:

Laravel Controller Code:

orWhere(DB::raw("concat(first_name, ' ', last_name)"), 'LIKE', "%".$search."%")
                       ->get();
  
        dd($members);
    }
}

Result

Array
(
    [0] => Array
        (
            [id] => 127
            [first_name] => Ridham
            [last_name] => Kakadiya
        )
)

Don’t miss : laravel group by

Example 2 :

Laravel Controller Code:

whereRaw("concat(first_name, ' ', last_name) like '%" .$search. "%' ")
                       ->get();
  
        dd($members);
    }
}

Result

Array
(
    [0] => Array
        (
            [id] => 127
            [first_name] => Ridham
            [last_name] => Kakadiya
        )
)

Example 3:

Laravel Controller Code:

where(function ($q) use ($search) {
                            $q->orWhere('first_name', 'like', "%{$search}%")
                              ->orWhere('last_name', 'like', "%{$search}%");
                        })
                       ->get();
  
        dd($members);
    }
}

Result

Array
(
    [0] => Array
        (
            [id] => 127
            [first_name] => Ridham
            [last_name] => Kakadiya
        )
)

I hope you get an idea about laravel search query.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

laravel search query – How to Search First Name and Last Name in Laravel Query?