MySQL | 2 DIFFERENT SOLUTIONS
\n# Solution 1\n\nUPDATE Salary\n    SET sex = (Case sex \n                WHEN \'m\' THEN \'f\'\n                ELSE \'m\'\n              END ) \n\n#Solution 
```\n# Solution 1\n\nUPDATE Salary\n    SET sex = (Case sex \n                WHEN \'m\' THEN \'f\'\n                ELSE \'m\'\n              END ) \n\n#Solution  2\n\nUPDATE Salary\nSET sex = IF(sex = "m","f","m");\n```\n
['Ordered Set', 'MySQL']