Laravel - Where null and Where not null eloquent query example

April 2, 2018 | Category : Laravel 5.6 Laravel 5.5 Laravel 5 SQL MySQL Laravel PHP

if you are a starter or learner laravel then you have in mind how to check where null or where not null condition using laravel eloquent model when you are writing eloquent query. if you write query for SQL then it is very easy syntax and families with where null and not null condition.

In this small tutorial i will let you know how you can write query for where null and where not null condition. here i will write core SQL query and then convert it into laravel query builder using db. So just see bellow example and see how it is works.

we have following solution on SQL and Laravel query builder:

1) IS NULL = whereNull()

2) IS NOL NULL = whereNotNull()

Where Null Query:

SQL Query:

SELECT * FROM users

WHERE name IS NULL;

Laravel Query:

DB::table('users')

->whereNull('name')

->get();

Where Not Null Query:

SQL Query:

SELECT * FROM users

WHERE name IS NOT NULL;

Laravel Query:

DB::table('users')

->whereNotNull('name')

->get();

I hope you found your best solution....