小弟在此等候回答。

reversal

update data set description  
=
select  left(description,charindex('<Br>',description) -1) as description  from data where num in(
select num from data
where description like'%<Br>%')

where where description like'%<Br>%'


我的意思是，把description修改成查询出的 ,但是我这样写不可以，为什么？

prajna

因为子查询出的有多个值

nankeny

Try:

update data set description  
=left(description,charindex('<Br>',description) -1)
where description like'%<Br>%'

cv4bf5d65fd

update data set description = left(description,charindex('<Br>',description) -1)  
where description like'%<Br>%'

fanfan1980

--try

update data set description=left(description, charindex('<Br>', description)-1)
from data
where charindex('<Br>', description)>0

unkmass

update data set description
=
select left(description,charindex('<Br>',description) -1) as description from data where num in(
select num from data
where description like'%<Br>%')

where where description like'%<Br>%'
-----------
此处连续两个where能不出问题吗!

prajna

楼上的锐利阿。。。竟然没人看到。。。

lancelover

update data set description
=
select left(description,charindex('<Br>',description) -1) as description from data where num in(
select num from data
where description like'%<Br>%')