Wherenotnull laravel

Laravel orWhere

$camps = $field->camps()->where('status', 0)->where(function ($q) {
    $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();

Source: laracasts.com

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Larave whereNotNull

# whereNull
$users = DB::table('users')
  ->whereNull('updated_at')
  ->get();
# whereNotNull
$users = DB::table('users')
  ->whereNotNull('updated_at')
  ->get();

Wherenotnull laravel

$users = User::whereNotNull('email')->get();
dd($users); or dd($users->count());

Similar codes

1 vote119 views1 answer
Laravel + join 2 eloquent queries
PHP Laravel
1 vote112 views1 answer
Datediff in hour query builder laravel
PHP Laravel
0 vote101 views1 answer
Laravel valet refresh env
PHP Laravel
7 votes121 views6 answers
Unique validation on update laravel
PHP Laravel
2 votes112 views1 answer
Laravel asset
PHP Laravel
0 vote171 views1 answer
Custom timestamp column laravel
PHP Laravel
0 vote146 views1 answer
How to clear artisan in laravel
PHP Laravel
0 vote114 views1 answer
Hint extension in visual studio code for laravel
PHP Laravel
4 votes133 views4 answers
Raw queries in laravel
PHP Laravel
0 vote131 views3 answers
Permissions for laravel deployment
PHP Laravel