Swap Gender Values

Write a single UPDATE statement that swaps all 'm' values with 'f' and all 'f' with 'm' in the sex column. Do not use any temporary table or SELECT.

Table schema

Salary(id INT PRIMARY KEY, name VARCHAR(50), sex CHAR(1), salary INT)

Sample data

id | name | sex | salary
1 | A | m | 2500
2 | B | f | 1500
3 | C | m | 5500
4 | D | f | 500