下面是过滤符合带*@cnkpa.com 这种格式邮箱都要过滤CREATE TABLE Common_EdmMailList
(
[Type] int not null, --0黑名单 1白名单
Email nvarchar(50) not null,
primary key([Type],Email)
)GOinsert Common_EdmMailList select 0 ,'*@cnkpa.com'
GO1.string emailTo="[email protected];[email protected];[email protected];"2.DataTable ="select * from dbo.Common_EdmMailList where Type =0 and Email like '*%'";1,2 比较
得到结果emailTo="[email protected];[email protected];"
(
[Type] int not null, --0黑名单 1白名单
Email nvarchar(50) not null,
primary key([Type],Email)
)GOinsert Common_EdmMailList select 0 ,'*@cnkpa.com'
GO1.string emailTo="[email protected];[email protected];[email protected];"2.DataTable ="select * from dbo.Common_EdmMailList where Type =0 and Email like '*%'";1,2 比较
得到结果emailTo="[email protected];[email protected];"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货