mysql select * from table where column a value = column b value laravel

Question

Im trying to query a table with column called completed and column called follow_ups among other columns - using laravel im trying to

 select * from table where completed > follow_ups 
 select * from table where completed = follow_ups

using laravel model im running the following

 $followUps = TestFollowups::where('follow_ups', '>', 'completed')->get();

I dont have to use laravels model system i can write a manual query as well but unsure what the query should look like. Can anyone help please

https://stackoverflow.com/questions/30331437/laravel-eloquent-compare-column-values — Angad Dubey, Nov 18 '17 at 01:39

score 0 · Answer 1 · edited Nov 18 '17 at 02:53

0

You can use:

whereRaw(select * from table where completed > follow_ups)

edited Nov 18 '17 at 02:53

ekhumoro

answered Nov 18 '17 at 02:20

Derrick Noutais

1 Answers1