MySQL查询案例

Question

这是我的代码，我有2列-- Modem = String，Total = Integer

SELECT `Modem`, `Total`,
CASE `Modem` WHEN 'Yes' THEN
(`Total`+ 50)
ELSE
(`Total`+ 0)
END AS ModemAndTotal
FROM invoices

我需要当Modem = "Yes“将50添加到总(总计+ 50)中

Answer 1

试一试如下：

SELECT `Modem`, `Total`, CASE WHEN `Modem` = 'Yes' THEN (`Total`+ 50)
                         ELSE
                         `Total`
                        END AS ModemAndTotal
FROM invoices