Laravel Eloquent Compare Column Values

Question

Eloquent's where() seems not working when comparing two column values. How to fix it?

Sample code:

->where('table_1.name', '=', 'table_2.name')

But works on:

->where('table_1.name', '=', 'john')

question from:https://stackoverflow.com/questions/30331437/laravel-eloquent-compare-column-values

Answer 1

Escaping is unnecessary in this case, you can use whereRaw():

->whereRaw('table_1.name = table_2.name')