mysql中如果未null则输出0_如果MySQL中的字段为null,则返回0

在MySQL中，有一种方法来设置“总”字段为零，如果他们是NULL？

这里是我有：

SELECT uo.order_id, uo.order_total, uo.order_status,

(SELECT SUM(uop.price * uop.qty)

FROM uc_order_products uop

WHERE uo.order_id = uop.order_id

) AS products_subtotal,

(SELECT SUM(upr.amount)

FROM uc_payment_receipts upr

WHERE uo.order_id = upr.order_id

) AS payment_received,

(SELECT SUM(uoli.amount)

FROM uc_order_line_items uoli

WHERE uo.order_id = uoli.order_id

) AS line_item_subtotal

FROM uc_orders uo

WHERE uo.order_status NOT IN ("future", "canceled")

AND uo.uid = 4172;

数据很好，除了NULL字段应该为0。

如何在MySQL中为NULL返回0？