Sometimes you need to check for table columns that have a condition where the value is not null and to do that you can make use of the "whereNotNull" clause.
whereNotNull Example
Below is how you can query the model with "whereNotNull" clause.
whereNotNull Example
Below is how you can query the model with "whereNotNull" clause.
Article::query()->whereNotNull('authored_at')->get();whereNull Example
To get the inverse value which is the column that has a null value then you can use "whereNull" clause.
Article::query()->whereNull('authored_at')->get();
Leave a reply