UPDATE salary SET sex = IF(sex = 'm', 'f', 'm')
UPDATE salary SET sex = CASE sex WHEN "m" THEN "f" ELSE "m" END ;
SELECT *,CASE sex WHEN 'f' THEN 'm' ELSE 'f' END AS 'change' FROM `salary`
SELECT *,IF (sex='f','m','f') AS 'change' FROM `salary`
case *when
可以是多个三元式校验
SELECT a.`id`,CASE a.id WHEN '1' THEN a.`desc` WHEN '2' THEN a.`desc` ELSE 'kong' END FROM `a`