kafka条件查询excel拼接

1
SELECT COUNT(*) FROM wiseweb_crawler_metasearch_page20171214 WHERE (content like '%内蒙古%'or    content like '%呼和浩特%'or    content like '%赛罕区%'or    content like '%土默特左旗%'or    content like '%托克托县%'or    content like '%和林格尔县%'or    content like '%清水河县%'or    content like '%武川县%'or    content like '%包头%'or    content like '%昆都仑%'or    content like '%石拐区%'or    content like '%白云鄂博%'or    content like '%土默特右旗%'or    content like '%固阳县%'or    content like '%达尔罕茂明安联合旗%'or    content like '%乌海市%'or    content like '%海勃湾区%'or    content like '%乌达区%'or    content like '%赤峰%'or    content like '%阿鲁科尔沁旗%'or    content like '%巴林左旗%'or    content like '%巴林右旗%'or    content like '%林西县%'or    content like '%克什克腾旗%'or    content like '%翁牛特旗%'or    content like '%喀喇沁旗%'or    content like '%宁城县%'or    content like '%敖汉旗%'or    content like '%通辽%'or    content like '%科尔沁%'or    content like '%开鲁县%'or    content like '%库伦旗%'or    content like '%奈曼旗%'or    content like '%扎鲁特旗%'or    content like '%霍林郭勒%'or    content like '%鄂尔多斯%'or    content like '%东胜区%'or    content like '%康巴什区%'or    content like '%达拉特旗%'or    content like '%准格尔旗%'or    content like '%鄂托克前旗%'or    content like '%鄂托克旗%'or    content like '%杭锦旗%'or    content like '%乌审旗%'or    content like '%伊金霍洛旗%'or    content like '%呼伦贝尔%'or    content like '%海拉尔区%'or    content like '%扎赉诺尔区%'or    content like '%阿荣旗%'or    content like '%莫力达瓦%'or    content like '%鄂伦春自治旗%'or    content like '%鄂温克族自治旗%'or    content like '%陈巴尔虎旗%'or    content like '%新巴尔虎左旗%'or    content like '%新巴尔虎右旗%'or    content like '%满洲里%'or    content like '%牙克石市%'or    content like '%扎兰屯%'or    content like '%额尔古纳%'or    content like '%根河市%'or    content like '%巴彦淖尔%'or    content like '%五原县%'or    content like '%磴口县%'or    content like '%乌拉特前旗%'or    content like '%乌拉特中旗%'or    content like '%乌拉特后旗%'or    content like '%杭锦后旗%'or    content like '%乌兰察布%'or    content like '%卓资县%'or    content like '%化德县%'or    content like '%商都县%'or    content like '%兴和县%'or    content like '%凉城县%'or    content like '%察哈尔%'or    content like '%四子王旗%'or    content like '%丰镇市%'or    content like '%兴安盟%'or    content like '%乌兰浩特%'or    content like '%阿尔山%'or    content like '%扎赉特旗%'or    content like '%突泉县%'or    content like '%锡林郭勒盟%'or    content like '%二连浩特%'or    content like '%锡林浩特%'or    content like '%阿巴嘎旗%'or    content like '%苏尼特左旗%'or    content like '%苏尼特右旗%'or    content like '%东乌珠穆沁旗%'or    content like '%西乌珠穆沁旗%'or    content like '%太仆寺旗%'or    content like '%多伦县%'or    content like '%阿拉善盟%'or    content like '%阿拉善%'or    content like '%额济纳旗%'or    content like '%杨阿麟%'or    content like '%云宗元%'or    content like '%张建成%'or    content like '%白晓春%'or    content like '%胡越瑛%'or    content like '%高玺龙%'or    content like '%曲国民%'or    content like '%牛草宽%'or    content like '%农村信用社%')AND (gathertime BETWEEN '2018-01-23 00:00:01' AND '2018-01-23 23:59:59')

 

社%'or
3	content like '%	内蒙古自治区农村信用合作社	%'or	content like '%内蒙古自治区农村信用合作社%'or
4	content like '%	内蒙古自治区信用社	%'or	content like '%内蒙古自治区信用社%'or
5	content like '%	内蒙古自治区农信社	%'or	content like '%内蒙古自治区农信社%'or
6	content like '%	内蒙古自治区信用联社	%'or	content like '%内蒙古自治区信用联社%'or
7	content like '%	内蒙古自治区农信联社	%'or	content like '%内蒙古自治区农信联社%'or
8	content like '%	内蒙古自治区农联社	%'or	content like '%内蒙古自治区农联社%'or
9	content like '%	内蒙古农村信用社联合社	%'or	content like '%内蒙古农村信用社联合社%'or
10	content like '%	内蒙古农村信用联社	%'or	content like '%内蒙古农村信用联社%'or
11	content like '%	内蒙古农村信用合作社	%'or	content like '%内蒙古农村信用合作社%'or
12	content like '%	内蒙古信用社	%'or	content like '%内蒙古信用社%'or
13	content like '%	内蒙古农信社	%'or	content like '%内蒙古农信社%'or
14	content like '%	内蒙古信用联社	%'or	content like '%内蒙古信用联社%'or
15	content like '%	内蒙古农信联社	%'or	content like '%内蒙古农信联社%'or
16	content like '%	内蒙古农联社	%'or	content like '%内蒙古农联社%'or
17	content like '%	海勃湾区	%'or	content like '%海勃湾区%'or
18	content like '%	乌达区	%'or	content like '%乌达区%'or
19	content like '%	赤峰	%'or	content like '%赤峰%'or
20	content like '%	阿鲁科尔沁旗	%'or	content like '%阿鲁科尔沁旗%'or
21	content like '%	巴林左旗	%'or	content like '%巴林左旗%'or
22	content like '%	巴林右旗	%'or	content like '%巴林右旗%'or
23	content like '%	林西县	%'or	content like '%林西县%'or
24	content like '%	克什克腾旗	%'or	content like '%克什克腾旗%'or
25	content like '%	翁牛特旗	%'or	content like '%翁牛特旗%'or
26	content like '%	喀喇沁旗	%'or	content like '%喀喇沁旗%'or
27	content like '%	宁城县	%'or	content like '%宁城县%'or
28	content like '%	敖汉旗	%'or	content like '%敖汉旗%'or
29	content like '%	通辽	%'or	content like '%通辽%'or
30	content like '%	科尔沁	%'or	content like '%科尔沁%'or
31	content like '%	开鲁县	%'or	content like '%开鲁县%'or
32	content like '%	库伦旗	%'or	content like '%库伦旗%'or
33	content like '%	奈曼旗	%'or	content like '%奈曼旗%'or
34	content like '%	扎鲁特旗	%'or	content like '%扎鲁特旗%'or

 

posted @ 2018-01-23 17:57  rjm123456  阅读(437)  评论(0编辑  收藏  举报