update
m
set
m
=
(
case
when
m
=
'
男
'
then
'
女
'
else
'
男
'
end
)
where
m
<>
''
转载于:https://www.cnblogs.com/mianshi/archive/2010/12/01/1893849.html