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

10 votes244 views2 answers
Create model in laravel command line
PHP Laravel
4 votes254 views2 answers
Laravel session forget
PHP Laravel
2 votes270 views1 answer
Laravel check if session variable exists
PHP Laravel
1 vote259 views1 answer
Laravel 8 validation required if another field is not null
PHP Laravel
0 vote245 views1 answer
Laravel if elseon join
PHP Laravel
7 votes302 views1 answer
Laravel if syntax
PHP Laravel
0 vote265 views1 answer
Laravel migration add date of birth column
PHP Laravel
1 vote272 views1 answer
Break and continue in laravel
PHP Laravel
3 votes247 views2 answers
Current user laravel
PHP Laravel
6 votes240 views4 answers
Laravel previous url
PHP Laravel