一个SQL语句的构建，请大家帮忙出主意，分数不够可以再加

[qiaohj]

当字段A等于X1或X2时，A=0，当字段A不等于X1且不等于X2时，A=1，当字段A等于X3时，
A=X3

[eddy8863]

update Table set A='0' where A in [X1,X2]
update Table set A='1' where A not in [X1,X2]
update Table set A=X3 where A1=X3

[Yang_]

select case when a=x1 or a=x2 then 0 when a=x3 then x3 else 1 end as a
from .....

x1 x2 x3是值哦

[Yang_]

没说清楚需求
逻辑好像也有点问题哦