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







Follow us
facebooklogo github instagram twitter

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock or some other adblocking software which is preventing the page from fully loading.

We need money to operate the site, and almost all of it comes from our online advertising.

Please add websolutionstuff to your ad blocking whitelist or disable your adblocking software.

×