Scroll To Top
Blog

Update Male TO Female and Female To Male with single query

By Satyapriya Nayak Apr 09, 2013
Update Male TO Female and Female To Male with single query
UPDATE    employee
SET             
gender = CASE gender WHEN 'male' THEN 'female' WHEN 'female' THEN 'male'
ELSE gender
END