mySql Update Cases Not Working Properly

Question

In the query below only first Two cases are working why

UPDATE `FundCategory` SET `fundCategoryValue` = 
    CASE 
    WHEN `fundCategoryId` = '7' THEN fundCategoryValue + 700 
    WHEN `fundCategoryId` = '5' THEN fundCategoryValue - 700 
    WHEN `fundCategoryId` = '5' THEN fundCategoryValue + 700 
    WHEN `fundCategoryId` = '7' THEN fundCategoryValue - 700 

    ELSE `fundCategoryValue` 
    END
    WHERE `fundCategoryId` IN('7','5','5','7')

Possible duplicate of [MySQL update CASE WHEN/THEN/ELSE](http://stackoverflow.com/questions/12754470/mysql-update-case-when-then-else) — B001ᛦ, Feb 01 '17 at 13:45
it will not go for next two condition WHEN `fundCategoryId` = '5' THEN fundCategoryValue + 700 WHEN `fundCategoryId` = '7' THEN fundCategoryValue - 700 . it always fulfill first two condition — krishn Patel, Feb 01 '17 at 13:46

score 2 · Answer 1 · answered Feb 01 '17 at 13:46

2

The conditions repeate after the first two... and the case statement stops when it found a working condition... so the last two can not work.

answered Feb 01 '17 at 13:46

Jan Zeiseweis

3,718
2
17
24

score 0 · Answer 2 · answered Feb 01 '17 at 13:50

You have the same condition repeated twice:

WHEN `fundCategoryId` = '7' THEN fundCategoryValue + 700 
WHEN `fundCategoryId` = '5' THEN fundCategoryValue - 700 
WHEN `fundCategoryId` = '5' THEN fundCategoryValue + 700 
WHEN `fundCategoryId` = '7' THEN fundCategoryValue - 700

mySql Update Cases Not Working Properly

2 Answers2