• 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
    
  • 相关阅读:
    docker三剑客之docker compose
    docker三剑客之一docker compose
    dockerfile创建镜像(二)
    dockerfile创建镜像
    dockerfile创建镜像
    端口映射和容器映射
    鼠标点击左侧字母,字母变色
    body滚动时左侧菜单固定
    左侧菜单收缩展开
    车林通购车之家--购车计算器模块--算法js
  • 原文地址:https://www.cnblogs.com/zhanglin123/p/8337136.html
Copyright © 2020-2023  润新知