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 ?
- Angular Use CKEditor Example Tutorial
- How to Use Multiple Select Dropdown in Laravel?
- Angular 9 Image Upload with Crop Example
- Files Upload on Button Click in PHP Dropzone Example
- PHP Dropzone Allow only One File to Upload Example
- PHP Dropzone Allow only Images to Upload Example
- PHP Dropzone Delete Uploaded File Example
- Livewire CRUD Laravel 7 Example