627. Swap Salary

https://leetcode.com/problems/swap-salary/

Swap Salary - LeetCode

update Salary set sex = if (sex = 'm', 'f', 'm');

best

UPDATE Salary
SET sex = (CASE WHEN sex = 'm'
                THEN 'f'
                ELSE 'm'
          END);