⭐2 Accepted Solutions⭐
DO UPVOTE IF YOU LIKE MY SOLUTIONS :)\n\n# 1.\nUPDATE salary\nSET sex = CASE sex\n    WHEN \'f\' THEN \'m\'\n    WHEN \'m\' THEN \'f\'\nEND\n\n# 2.\nUpdate sala
DO UPVOTE IF YOU LIKE MY SOLUTIONS :)\n```\n# 1.\nUPDATE salary\nSET sex = CASE sex\n    WHEN \'f\' THEN \'m\'\n    WHEN \'m\' THEN \'f\'\nEND\n\n# 2.\nUpdate salary \nSET sex = IF(sex =\'f\',"m","f");\n```\nIf you have any doubts, feel free to ask...\nIf you understand the concept. Don\'t Forget to upvote \uD83D\uDE0A
['MySQL']