Laravel 9 whereNull / whereNotNull Query Example

Websolutionstuff | Oct-18-2022 | Categories : Laravel

In this article, we will see the laravel 9 whereNull / whereNotNull query example. In laravel 9 additional where clauses provide many built-in where methods. So, we will learn how to write queries for whereNull and whereNotNull methods in laravel 9. Also, laravel 9 provides the same method as orWhereNull and orWhereNotNull.

The whereNull() method is used to check the value of the given column is NULL and The whereNotNull() method is used to check the value of the given column is not NULL. Also, we will see examples of SQL query and syntax of IS NULL and IS NOT NULL.

So, let's see a whereNull query in laravel 9 and a whereNotNull query in laravel 9.

Syntax of IS NULL in SQL

The IS NULL is used to check the empty value.

SELECT column_names
FROM table_name
WHERE column_name IS NULL;

 

Example 1:

In this example, we will retrieve all customers with a NULL value in the Address field. 

SELECT CustomerName, ContactName, Address
FROM Customers
WHERE Address IS NULL;

 

 

Syntax of the whereNull()

 In laravel whereNull() function add a column to check the condition.

whereNull(Column Name);

 

Example 2:

In this example, we will retrieve all records with the updated_at column value being NULL.

$users = DB::table('users')
                ->whereNull('updated_at')
                ->get();

 

Syntax of IS NOT NULL in SQL

The IS NOT NULL is used to check the non-empty value.

SELECT column_names
FROM table_name
WHERE column_name IS NOT NULL;

 

 

Example 3:

In this example, we will retrieve all customers with a value in the Address field. 

SELECT CustomerName, ContactName, Address
FROM Customers
WHERE Address IS NOT NULL;

 

Syntax of the whereNotNull()

  In laravel whereNotNull() function add a column to check the condition.

whereNotNull(Column Name);

 

Example 4:

In this example, we will retrieve all records from the user's table with the updated_at column value not NULL.

$users = DB::table('users')
                ->whereNotNull('updated_at')
                ->get();

 


You might also like:

Recommended Post
Featured Post
How to Add Image to PDF file in Laravel 10
How to Add Image to PDF file i...

Greetings, Laravel enthusiasts! Today, let's explore a practical aspect of web development – adding images to...

Read More

Dec-20-2023

How to Install Composer on Ubuntu 22.04
How to Install Composer on Ubu...

Hey there! If you're diving into the world of PHP development on your Ubuntu 22.04 machine, you'll likely come a...

Read More

Jan-10-2024

How to Upgrade PHP 7.4 to 8.0 in Ubuntu
How to Upgrade PHP 7.4 to 8.0...

Hey there! I recently faced the need to upgrade my PHP version from 7.4 to the latest 8.0 on my Ubuntu server. It might...

Read More

Nov-06-2023

Dropzone Image Upload Tutorial In Laravel 6/7
Dropzone Image Upload Tutorial...

In this article, we will see dropzone image upload in laravel 6/7. To upload images and files we will use dropzone....

Read More

Sep-21-2020