MySQL update CASE WHEN/THEN/ELSE - Stack Overflow

UPDATE `table` SET `uid` = CASE WHEN id = 1 THEN 2952 WHEN id = 2 THEN 4925 WHEN id = 3 THEN 1592 END. Lo and behold, the ...

stackoverflow.com