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

you can accept my answer for further readers if it was helpful :) — Limon Monte, Jun 05 '15 at 11:54
Possible duplicate of [Compare two colonne for some table with eloquent laravel](http://stackoverflow.com/questions/25311540/compare-two-colonne-for-some-table-with-eloquent-laravel) — Ivanka Todorova, May 17 '16 at 07:27

score 92 · Accepted Answer · answered May 19 '15 at 16:44

92

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

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

answered May 19 '15 at 16:44

Limon Monte

1

Nice. Thanks! I also answered my question in addition to your solution. I'll vote up your answer when my vote credits regenerates. – Jake Opena May 19 '15 at 16:56
is there any way to do this using "where " Clause – Prince Arora Feb 19 '18 at 10:58

score 77 · Answer 2 · edited Aug 15 '16 at 03:50

77

You can use where column:

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

edited Aug 15 '16 at 03:50

Pang

answered Aug 15 '16 at 03:46

Carolyn Lim

1

Just want to add that this method is only added in laravel 5. Use method in other answer if you are working on laravel 4 project like me. – cytsunny Sep 20 '16 at 09:35
5

You can also pass a comparison operator and/or an array of multiple conditions. eg, ->whereColumn([ ['first_name', '=', 'last_name'], ['updated_at', '>', 'created_at'] ]); – cdwyer Jul 24 '18 at 20:47

score 16 · Answer 3 · answered May 19 '15 at 16:54

16

I figured it out. 'table_2.name' is interpreted as plain string and not a mysql table column.

Possible solutions:

Wrap 'table_2.name'with \DB::raw()

->where('table_1.name', '=', \DB::raw('table_2.name'))

Wrap the entire expression with whereRaw() (based on @limonte's answer)
```
->whereRaw('table_1.name = table_2.name')
```

answered May 19 '15 at 16:54

Jake Opena

1

Yes. Thank you. I just added an alternative solution. Not necessarily a better solution :) – Jake Opena May 19 '15 at 16:57

3 Answers3