查询商品价格,如果price1大于0,则商品价格为price1,否则为price2
方法一:
SELECT
(
CASE
WHEN price1 > 0 THEN
price1
ELSE
price2
END
) AS money
WHERE
goods_id = '122'
FROM
goods
方法二:
SELECT
`IF` (price1 > 0, price1, price2) AS money
WHERE
good_id = '122'
FROM
goods