如何在SQL語句select中根据某个字段值，修改另外一个字段的值

[cst19841103]

select price, beizhu from bank。我想根据price中的值如果为2或者8的时候，将beizhu字段修改为'新开户'，请教各位这个应该怎么写比较好？谢谢

[Yole]

update bank set beizhu ='新开户' from bank  where price in (2,8)

[cst19841103]

引用 1 楼 u010192842 的回复:

update bank set beizhu ='新开户' from bank  where price in (2,8)

我是想查询的时候修改，不需要修改数据库中的值 只是查询展示用而已

[Yole]

select price,case when  beizhu = 2 or  beizhu = 8 then '新开户' else beizhu end as beizhu from bank

[开着拖拉机泡妞]

select price, case when price in(2,8) then beizhu=‘新开户’ else beizhu end as beizhu from bank

[cst19841103]

引用 4 楼 TravyLee 的回复:

select price, case when price in(2,8) then beizhu=‘新开户’ else beizhu end as beizhu from bank

谢谢 select case when price in ('0', '10') then '已存档' else beizhu end as 'ss ' from dbo.bank;

[Yole]

select price,
case  when  price= 2 or price=8 then '新开户' else beizhu end as beizhu 
from bank

[秃驴子]

 update 
 set beizhu='新开户'
 from bank
 where  price in (2,8)

[秃驴子]

select
price,
case price 
when 2 then '新开户',
when 8 then '新开户',
else beizhu 
end as 'beizhu'
from bank

[秃驴子]

上面多写了逗号

[LongRui888]

如果是查询： select price,case when price IN (2,8) then '新开户' else beizhu end beizhu from bank 如果是更新： update bank set beizhu = '新开户' where price IN (2,8)