Question : larave whereNotNull
Answered by : carlos-hernandez
# whereNull
$users = DB::table('users') ->whereNull('updated_at') ->get();
# whereNotNull
$users = DB::table('users') ->whereNotNull('updated_at') ->get();Source : | Last Update : Tue, 23 Mar 21
Question : laravel orWhere
Answered by : hassan-joseph
$camps = $field->camps()->where('status', 0)->where(function ($q) { $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();Source : https://laracasts.com/discuss/channels/eloquent/use-orwhere-in-eloquent | Last Update : Tue, 27 Oct 20
Question : laravel not in query
Answered by : lokesh-ramchandani-in6l3jq294i2
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();Source : | Last Update : Sat, 03 Oct 20