Comparing two columns in Laravel 5

Question

I am using Laravel

Let's say, I have two date fields in my table. If I want to compare them, i can do whereRaw clause.

$query->whereRaw('date1 > date2')->get()

Is there a way to make a modification to date2 inside this query, so it is actually date2-1day?

Something like:

$query->whereRaw('date1 > (date2-1day)')->get()

jedrzej.kurylo · Accepted Answer · 2016-09-06 13:27:38Z

3

You are free to call any SQL code in the "raw" part of your query, so you could do sth like below:

$query->whereRaw('date1 > DATE_SUB(date2, INTERVAL 1 DAY)')->get();

Keep in mind that executing SQL code this way will make your queries work only in databases that support such functions.

answered Sep 6, 2016 at 13:27

jedrzej.kurylo

41.1k10 gold badges108 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Akshay K Nair · Accepted Answer · 2021-12-10 05:53:39Z

0

Another way would be using whereColumn like

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

OR

UserTable::whereRaw('column1 != column2')->get();

answered Dec 10, 2021 at 5:53

Akshay K Nair

1,52621 silver badges36 bronze badges