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') 

Answer 1

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

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

Answer 2

You can use where column:

->whereColumn('table_1.name', 'table_2.name')