eloquent query that sum of two column greater than a number

i want to build an eloquent query sum of two column greater than a number like this

$query = Transaction::query();
$query = $query->where('plan_price - final_price','>=',5);

how ?

Best Answer

Level 73

Transaction::whereRaw('plan_price - final_price >= 5');

Should work.

Level 2

I think you'll have to use the \DB::raw(), as query builder doesn't support such statements at the moment.

$query = Transaction::query()->where(\DB::raw('(plan_price - final_price) >= 5'));

Please or to participate in this conversation.