er-pkumar/search_multiple_column.md

Last active May 7, 2024 06:11

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/er-pkumar/501b5f0290b93f77b5d064dcc8136add.js"></script>
Save er-pkumar/501b5f0290b93f77b5d064dcc8136add to your computer and use it in GitHub Desktop.

Laravel way to search across multiple column in table

Raw

$searchString = $request->validated('keyword');
$user = User::whereAny(
    [
        'first_name',
        'last_name',
        'email'
    ],
    'ilike',
    "{$searchString}%"
)->get();