Update table set gender = (case when gender='Male' then 'Female' else 'Male' end)
Update table_name set Gender= case when Gender='Female' then 'Male' when Gender='Male' then 'Female' end where Gender in('Female','Male')