How to Check “if not null” with Laravel Eloquent

To check “if not null” with Laravel Eloquent, you can use the whereNotNull() method. The equivalent to the IS NOT NULL condition in Laravel Eloquent is the whereNotNull() method that allows us to verify if a specific column’s value is not NULL.

For instance, let’s say you have a products table, and you want to retrieve all products where the sku_id is not null:

$products = Product::whereNotNull('sku_id')->get();

If you are only interested in the first result, you can use the first() method instead:

$products = Product::whereNotNull('sku_id')->first();

To retrieve products where multiple fields are not null, you can chain multiple whereNotNull methods.

$products = Product::whereNotNull('sku_id')->whereNotNull('price')->get();

Laravel Eloquent whereNull()

To retrieve products where sku_id is null, you can use the whereNull() method.

$products = Product::whereNull('sku_id')->get();

Always call the get() method at the end to execute the query and retrieve the results.

Using Laravel DB Facade

If you prefer using the DB facade, you can use the whereNotNull() method like this:

$products = DB::table('products')
            ->whereNotNull('sku_id')
            ->get();

And whereNull() method looks like this:

$products = DB::table('products')
            ->whereNull('sku_id')
            ->get();

Summary table

That’s all!

Krunal

Krunal Lathiya is a seasoned Computer Science expert with over eight years in the tech industry. He boasts deep knowledge in Data Science and Machine Learning. Versed in Python, JavaScript, PHP, R, and Golang. Skilled in frameworks like Angular and React and platforms such as Node.js. His expertise spans both front-end and back-end development. His proficiency in the Python language stands as a testament to his versatility and commitment to the craft.