查找字段值替换里面的内容

[Dotar]

select Change=Replace(Change,'Pass','select') from table


Change字段有多种值,什么方法可以将Change字段中 'Pass'和'No Pass'都查找替换成 'select'

[szm341]

update tb set Change=Replace(Change,'No Pass','select') where Change like '%No Pass%' update tb set Change=Replace(Change,'Pass','select') where Change like '%Pass%'

[骑着蜗牛去爬山]

update tb set col=replace(replace(col,'No Pass','select'),'Pass','select') where col like '%Pass%'

[asdf147asdf]

update 表 set change=replace(replace(change,'No Pass','select'),'Pass','select')

[开着拖拉机泡妞]

UPDATE TB
SET CHANGE=REPLACE(REPLACE(CHANGE,'NO ',''),'PASS','SELECT')

[kate_1988]

update tb set Change=Replace(Change,'No Pass','select') 

update tb set Change=Replace(Change,'Pass','select') 

[-Tracy-McGrady-]

select Change=Replace(Replace(Change,'No Pass','Pass'),'Pass','select') from table 
--先把No Pass替换成Pass，再把Pass替换成select

[Dotar]

引用 6 楼 yangsh0722 的回复:

SQL code ? 123 select Change=Replace(Replace(Change,'No Pass','Pass'),'Pass','select') from table --先把No Pass替换成Pass，再把Pass替换成select

OK! 上面一群人拿Update来忽悠我