How to use whereColumn() method in Laravel
Categorized as Laravel
Quick tip: you can use a pretty handy Eloquent method called
whereColumn() to verify if columns are equal. For example, you can find posts that have been updated or posts which have the same title and slug. Here is the code:
// Posts that have been updated Post::query() ->whereColumn('updated_at', '>', 'created_at') ->get(); // Posts with identical title and slug Post::query() ->whereColumn('title', 'slug') ->get();
Read more in the official documentation here.