Laravel Eloquent WhereNull() and whereNotNull() Example

Do you know how to use WhereNull() and whereNotNull() Laravel Eloquent.

In this post, I will explain how to use Laravel Eloquent  WhereNull() and whereNotNull().

you can use WhereNull() and whereNotNull()  with laravel 6, laravel 7, laravel 8 and laravel 9 application.

whereNull() will help you to get data with null values from the database.

whereNotNull() will help you to get data with not-null values from the database.

Lets look into the examples

How to use Laravel Eloquent WhereNull()

<?php
  
namespace App\Http\Controllers;  
use Illuminate\Http\Request;
use App\Post;
  
class UserController extends Controller
{    
    public function index()
    {
        $posts = Post::whereNull('author')->get();  
        dd($posts);
    }
}

Let’s see the SQL Query

select * from `posts` where `author` is null

How to use Laravel Eloquent whereNotNull()

<?php
  
namespace App\Http\Controllers;  
use Illuminate\Http\Request;
use App\Post;
  
class UserController extends Controller
{    
    public function index()
    {
        $posts = Post::whereNotNull('author')->get();  
        dd($posts);
    }
}

Let’s see the SQL Query

select * from `posts` where `author` is not null

Hope you like it.

Checkout More Awesome Laravel Tutorials