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....
Do you like below Tutorials ?
- Multidimensional Array Search By Value in PHP
- Laravel Install Font Awesome Icons Example
- How to Use Moment JS in Laravel?
- Angular 9 Get Environment Variables Example
- Angular Delete a Component From Cli Example
- How to Upload File from Local to Server using SSH?
- Angular Use CKEditor Example Tutorial
- How to Use Multiple Select Dropdown in Laravel?