Laravel 9 whereColumn Query Example

Websolutionstuff | Oct-21-2022 | Categories : Laravel

In this article, we will see laravel 9 whereColumn() query example. The whereCoulmn method is used to verify whether two columns are equal or not. So, we will learn whereColumn in laravel 9.

Laravel also provides orWhereColumn() method. So, you can also use whereColumn() with orWhereColumn() method in laravel.

So, let's see laravel 9 whereColumn() and compare two columns in laravel 9.

Syntax of whereColumn()

whereColumn('column name', 'operator', 'compare column name')

 

Example 1:

In this example, we will retrieve all those employee's records which are both column equals.

$employee = DB::table('employee')
                ->whereColumn('first_name', 'last_name')
                ->get();

 

Example 2:

You may also pass a comparison operator to the whereColumn method.

$users = DB::table('users')
                ->whereColumn('updated_at', '>', 'created_at')
                ->get();

 

Example 3:

You may also pass an array of column comparisons to the whereColumn method. These conditions will be joined using the and operator.

$users = DB::table('users')
                ->whereColumn([
                    ['first_name', '=', 'last_name'],
                    ['updated_at', '>', 'created_at'],
                ])->get();

 


You might also like:

Recommended Post
Featured Post
How to Install PHP DOM Extension in Ubuntu 23.04
How to Install PHP DOM Extensi...

In this tutorial, I will guide you through the process of installing the PHP DOM Extension in Ubuntu 23.04. The PHP DOM...

Read More

Jan-29-2024

How to Send E-mail Using Queue in Laravel 7/8
How to Send E-mail Using Queue...

Today I will show you how to send e-mail using queue in laravel 7/8, many times we can see some processes take...

Read More

Oct-30-2020

MilesWeb Review: Why Go for Its Shared Hosting?
MilesWeb Review: Why Go for It...

For finding the right web hosting provider, you need to do a lot of research. There are hundreds of web hosting provider...

Read More

Nov-12-2021

How To Remove Package From Laravel
How To Remove Package From Lar...

In this article, we will see how to remove the package from laravel. there are different ways to remove packages fr...

Read More

Oct-31-2022