query for multiple condition coumns laravel code example
Example 1: multiple logical condition in laravel query
$q->where(function ($query) {
$query->where('gender', 'Male')
->where('age', '>=', 18);
})->orWhere(function($query) {
$query->where('gender', 'Female')
->where('age', '>=', 65);
})
Example 2: laravel where multiple conditions on single colmn
$data = Users::where('type',1)
->where(function($query) {
return $query->whereDate('updated_at','!=', Carbon::today())
->orWhere('updated_at',null);
})
->get();