How? Getting the amount from Mysql with a condition, how?

Question

PHP

I have an invoice now

$all_win = 0;
foreach ($liveDrop as $live) {
            $all_win += Item::where('id', $live->item_id)->sum('sell_price');
}

Table

In my script now, the item id of all of this table is being detected and the sum of these Items is summed up. But I need to remake it so that it counts only those rows where key is NOT equal to L2MBD4 , that is, so that the calculation goes the same way, only rows where the column = L2MBD4 are not taken into account. How to do it?

Answer 1

select sum(sell_price) where key <> 'L2MBD4 '