Content Overview
Introduction
In this tutorial, we will learn how to query where null and where not null with eloquent in Laravel. I will use the raw query and convert into laravel eloquent.
For example:
Let's assume we have a table called the post with the following values.
Post Table
| Id | title | post_description |
| 1 | test title | this is test description |
| 2 | null | this is 2nd test description |
| 3 | 2nd title | null |
Where Not Null Query
SQL raw query
Select * from posts
where title IS NOT NULL;Laravel eloquent query
DB::table('posts')
->whereNotNull('title')
->get();Where Null Query
SQL raw query
select * from posts
where title IS NULL;Laravel eloquent query
DB::table('posts')
->whereNull('title')
->get();
