34,576
社区成员
发帖
与我相关
我的任务
分享
update Sscbetting
set zhangtai=(case when charindex('5',left(hm,charindex(',',hm)-1))>0
and charindex('6',right(hm,len(hm)-charindex(',',hm)))>0 then 'true' else 'false' end)
update tb
set hit = (case when charindex('2',left(TXT,charindex(',',TXT)-1))>0
and charindex('3',right(TXT,len(TXT)-charindex(',',TXT)))>0
then 'true' else 'false' end)
update tb set hit=true where charindex('2',left(TXT,charindex(',',TXT)-1))>0
and charindex('3',right(TXT,len(TXT)-charindex(',',TXT)))>0