I have a Table having the following column:

ID, Name, Designation, Salary, Contact, Address, Gender

Accidentally for all male Gender i have entered 'Female' and similarly for all Female gender i have entered 'Male'. For Exmaple

0023 Scott Developer 15000 4569865 Cliff_Eddington,USA Female

I the above line There should be Male instead of female. And there are all Male whose gender has been updated as Female. Same case for all Female Gender has been updated as Male.

Is there any Single query through which i can change all the Rows whose Gender is Male Change it to Female and All the Rows whose Gender is Female Change it to Male.