Multiple Where Laravel

[Solved] Multiple Where Laravel | Php - Code Explorer | yomemimo.com
Question : laravel where multiple conditions on single colmn

Answered by : nikhil-chauhan

//laravel
// here, i have used two different where condition on a single column
$today = Carbon::today();
$data = Users::where('type',1) ->where(function($query) use ($today) { return $query->whereDate('updated_at','!=', $today) ->orWhere('updated_at',null); }) ->get();
//another example ->
//when you need to use like and in_array functionality together
//when column value is like {tag:active} and you are checking with an array
$query->where(function($query) use ($filter_tags) { foreach($filter_tags as $tag){ $query->orWhere('user.tags', 'LIKE', "%{tag}%"); }
});

Source : | Last Update : Fri, 16 Oct 20

Answers related to multiple where laravel

Code Explorer Popular Question For Php