multi where condition sql laravel code example
Example 1: laravel where multiple conditions
$query->where([
['column_1', '=', 'value_1'],
['column_2', '<>', 'value_2'],
[COLUMN, OPERATOR, VALUE],
...
])
Example 2: laravel where multiple conditions on single colmn
// here, i have used two different where condition on a single column
$data = Users::where('type',1)
->where(function($query) {
return $query->whereDate('updated_at','!=', Carbon::today())
->orWhere('updated_at',null);
})
->get();