I have users table in which a city column . In this some city name like some Delhi and some Goa . I want to updates it's name . like change Delhi change with Goa & Goa change with Delhi .
update your_table set city = case when city = 'Delhi' then 'Goa' else 'Delhi' end where city in ('Delhi','Goa')