Search by amount laravel

Question

How can I find a record by the sum of the field values ?

I tried it like this, but there is no result

->where(DB::raw('sum(two_place,ona_place)'), '>', 5)

Answer 1

Sum() is an aggregate function, that will be used in context of grouping data. you should add the columns together instead.

->where(DB::raw('two_place + ona_place'), '>', 5)