✔️ Three quick MySQL solutions
Note: As of 12/04/2022, using the testcases yields an error (\'Invalid Testcase\'). However, submitting any of the following solutions works perfectly fine. \n\
**Note:** As of 12/04/2022, using the testcases yields an error (\'Invalid Testcase\'). However, submitting any of the following solutions works perfectly fine. \n\n<br>\n\n-- Solution #01: Using `CASE`\n```sql\nUPDATE Salary\nSET\n    sex = CASE sex\n            WHEN \'m\' THEN \'f\'\n            ELSE \'m\'\n          END;\n```\n\n<br>\n\n-- Solution #02: Using `IF`\n```sql\nUPDATE Salary\nSET sex = IF(sex=\'m\', \'f\', \'m\')\n```\n\n<br>\n\n-- Solution #03: Using `REPLACE`\n```sql\nUPDATE Salary\nSET sex = REPLACE(\'fm\', sex, \'\');\n```
['MySQL']