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 Create Dynamic Pie Chart In Laravel
How To Create Dynamic Pie Char...

In this article, we will see how to create a dynamic pie chart in laravel. charts are used to represent data i...

Read More

Jun-24-2020

How To Add Default Value Of Column In Laravel Migration
How To Add Default Value Of Co...

In this article, we will see how to add the default value of a column in laravel 10 migration. Here, we will learn...

Read More

May-01-2023

Custom Toastr Notification In Laravel 9
Custom Toastr Notification In...

In this article, we will see a custom toastr notification in laravel 9. we will create a custom notification using HTML,...

Read More

Sep-23-2022

How To Send Email Using Markdown Mailable Laravel 9
How To Send Email Using Markdo...

In this article, we will see how to send email using markdown mailable laravel 9. we will learn laravel 9 to s...

Read More

Aug-05-2022