求一批量删除条件(如果字段中没有@)

Question

delete from tb where charindex('@',emailaddress)=0

Answer 1

create table tb(
email varchar(200)
)
insert tb select '[email protected]'
insert tb select 'hv.com'
insert tb select '[email protected]'delete from tb where charindex('@',email)=0select * from tbdrop table tb/*
email                                                                                      
--------
[email protected]
[email protected]（所影响的行数为 2 行）
*/

Answer 2

delete tb where email not like '%@%'