求能实现这样功能的 SQL 语句，多谢！

Question

select id,ziduan1,(case when  charindex('school@',ziduan1 )=1 then ziduan2+'xyz' else ziduan2 end)as ziduan2 from biao

Answer 1

Select id,ziduan1,( Case When CharIndex('@',ziduan1)>0 Then ziduan2+'xyz' ELse ziduan2 End )As ziduan2 from biao

Answer 2

select id,ziduan1,case when left(ziduan2,7)='school@' then ziduan2+'zyz' else ziduan2 end  from biao

Answer 3

不好意思字段写错了
select id,ziduan1,case when left(ziduan1,7)='school@' then ziduan2+'xyz' else ziduan2 end  from biao

Answer 4

declare @a table(id int,ziduan1 varchar(50),ziduan2 varchar(50))
insert @a(id,ziduan1,ziduan2)
values(1,'abc','yuxi')
insert @a(id,ziduan1,ziduan2)
values(2,'[email protected]','haha')
insert @a(id,ziduan1,ziduan2)
values(3,'jsuehgja','haha')
insert @a(id,ziduan1,ziduan2)
values(4,'school@pieadf','haha')
insert @a(id,ziduan1,ziduan2)
values(5,'school@fufufuf','haha')
select * from @a
select id from @a where ziduan1 like 'school@%'
update @a set ziduan2=ziduan2+'xyz' where id in 
(select id from @a where ziduan1 like 'school@%')select * from @a

Answer 5

select id,ziduan1,(case when ziduan2 like 'school@%' then ziduan2+'zyz' else ziduan2 end ) As ziduan2 from biao