Hey, if you are searching about WhereNotNull() in laravel, I’m here to describe this to you today,
If you are suppose to find/fetch whether a field is NOT NULL in DB, it is possible to check that in Eloquent ORM in laravel.
Suppose you want to select all the results where notify_me column values are not null. In Laravel version >= 5.*, you can write it as given below
Using Query Builder Method
DB::table('users')->whereNotNull('notify_me')->get();or
Using Eloquent ORM Method
Users::whereNotNull('notify_me');whereNotNull() is a default method of Laravel.
There is one another method called WhereNull(). It can be used to check whether field is null or not. For example, if you want to check the null in the last_name field you can use WhereNull().
Using Query Builder Method
DB::table('users')->whereNull('last_name')->get();Using Eloquent ORM Method
Users::whereNull('last_name');