Laravel Eloquent whereColumn() Query Example

Admin   Laravel   384  2021-03-15 20:20:10

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 whereColumnmethod 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);

}

It will help you....