10-Apr-2023
.
Admin
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
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....
#Laravel 7
#Laravel
#Laravel 6