MySQL Query Case

Question

This is my code, i have 2 columns - Modem = String, Total = Integer

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

I need when Modem = "Yes" add 50 to total (Total + 50)

It is not clear what are you trying to achieve, do you really need 3rd column Modem and total? or you just want to replace column Total? — Alex
– Alex, Commented May 3, 2015 at 10:24

SMA · Accepted Answer · 2015-05-03 09:56:56Z

1

Try something like:

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

answered May 3, 2015 at 9:56

SMA

37.2k8 gold badges53 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Query Case

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related