select
*
from
tb
where
(
case
when
col=
'***'
then
'***'
else
'***'
end
)=
'***'
select
*
from
tb
where
(
case
when
col=
'***'
then
'***'
else
'***'
end
)=
'***'
转载于:https://www.cnblogs.com/volts0302/p/6128802.html