交换

update salary
set sex=    
	case sex        
	when 'f'         
	then 'm'        
	else 'f'
end

update salary
set sex=if(sex='f','m','f')

select 
if((mod(id,2)=1 and id=(select max(id) from seat)),id,if(mod(id,2)=1,id+1,id-1))as id,student
from seat
order by id 

select 
(case     
when id%2=1 and id=(select max(id) from seat) then id     
when id%2=1 then id+1 else id-1end) as id,student
from seat
order by id 

一般的简单when case语句放在from前