Laravel Eloquent whereColumn() Query Example

Hi Guys,

In this example,I will learn you how to use wherecolumn query in laravel.you can easy and simply use wherecolumn in laravel.

The whereColumn

method may be used to verify that two columns are equal.you can see bellow example how it is work.

Example 1:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereColumn('first_name','last_name')
                ->get();
    dd($users);
}

Example 2:

You can use comparison operator in this query. bellow this example.

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereColumn('updated_at', '<', 'created_at')
                ->get();
    dd($users);
}

Example 3:

The whereColumn method can also be passed an array of multiple conditions. These conditions will be joined using the and operator:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = DB::table('users')
                ->whereColumn([
                    ['first_name', '=', 'last_name'],
                    ['updated_at', '>', 'created_at'],
                ])->get();
    dd($users);
}

It will help you....