select count(*) from Huo_v where Area in ('北京','郑州','济南','枣庄','沈阳') and (Keywords like '%扬州%' or Keywords like '%泰州%' or Keywords like '%淮安%' or Keywords like '%宿迁%' or Keywords like '%盐城%' or Keywords like '%南通%' or Keywords like '%南京%' or Keywords like '%徐州%' or Keywords like '%连云港%' or Keywords like '%镇江%' or Keywords like '%常州%' or Keywords like '%无锡%' )
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Class] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Sender] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[AddTime] [datetime] NOT NULL ,
[Body] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Area] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Status] [bit] NULL ,
[Keywords] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
Huo_v表结构
估计也达不到你的要求
keywords 是这个全国城市的任意组合,个数不定,如(连云港,徐州,郑州)
union all
select 1 from Huo_v where Area='郑州' and ...
union all
select 1 from Huo_v where Area='济南' and ...
union all
select 1 from Huo_v where Area='枣庄' and ...
union all
select 1 from Huo_v where Area='沈阳' and ...select @@rowcount