2023-04-19 #laravel

Comparing two database columns in Laravel

When you want to compare two database columns in Laravel, you can't use where because it treats the argument you're comparing to as a value.

Instead, Laravel has a whereColumn method you can use to compare a value to another column's value.

// Retrieve posts that were updated after
// they were published.
->whereColumn('updated_at', '>', 'published_at')