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

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

laravel search query

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:

<?php
  
namespace App\Http\Controllers;
  
use App\Models\Member;
use DB;
  
class PakaController extends Controller
{
    /**
     * Write code on Method
     * created by Pakainfo.com
     * @return response()
     */
    public function index()
    {
        $search = "Ridham Ka";
        $members = Member::select("id", "first_name", "last_name")
                       ->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:

<?php
  
namespace App\Http\Controllers;
  
use App\Models\Member;
  
class PakaController extends Controller
{
    /**
     * Write code on Method
     * created by Pakainfo.com
     * @return response()
     */
    public function index()
    {
        $search = "Ridham Ka";
        $members = Member::select("id", "first_name", "last_name")
                       ->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:

<?php
  
namespace App\Http\Controllers;
  
use App\Models\Member;
  
class PakaController extends Controller
{
    /**
     * Write code on Method
     * created by Pakainfo.com
     * @return response()
     */
    public function index()
    {
        $search = "Ka";
        $members = Member::select("id", "first_name", "last_name")
                       ->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.

Pakainfo

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I’m a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Also Read This 👉   Frontaccounting API - Frontaccounting documentation - Frontaccounting tutorial