用戶:Liangent/prcadminself
外觀
update article set ideal_title='新村乡' where ideal_title='港城开发区新村乡'; update article set ideal_title='灵泉街道' where ideal_title='满洲里市灵泉街道'; update article set ideal_title='林海街道' where ideal_title='阿尔山市林海街道'; update article set ideal_title='新城街道' where ideal_title='阿尔山市新城街道'; update article set ideal_title='温泉街道' where ideal_title='阿尔山市温泉街道'; update article set ideal_title='天池镇' where ideal_title='阿尔山市天池镇'; update article set ideal_title='白狼镇' where ideal_title='阿尔山市白狼镇'; update article set ideal_title='五岔沟镇' where ideal_title='阿尔山市五岔沟镇'; update article set ideal_title='朝阳街道' where ideal_title='高密市朝阳街道'; update article set ideal_title='醴泉街道' where ideal_title='高密市醴泉街道'; update article set ideal_title='密水街道' where ideal_title='高密市密水街道'; update article set ideal_title='关堤乡' where ideal_title='开发区关堤乡'; update article set ideal_title='沁园街道' where ideal_title='济源市沁园街道'; update article set ideal_title='济水街道' where ideal_title='济源市济水街道'; update article set ideal_title='北海街道' where ideal_title='济源市北海街道'; update article set ideal_title='天坛街道' where ideal_title='济源市天坛街道'; update article set ideal_title='玉泉街道' where ideal_title='济源市玉泉街道'; update article set ideal_title='克井镇' where ideal_title='济源市克井镇'; update article set ideal_title='五龙口镇' where ideal_title='济源市五龙口镇'; update article set ideal_title='轵城镇' where ideal_title='济源市轵城镇'; update article set ideal_title='承留镇' where ideal_title='济源市承留镇'; update article set ideal_title='邵原镇' where ideal_title='济源市邵原镇'; update article set ideal_title='坡头镇' where ideal_title='济源市坡头镇'; update article set ideal_title='梨林镇' where ideal_title='济源市梨林镇'; update article set ideal_title='大峪镇' where ideal_title='济源市大峪镇'; update article set ideal_title='思礼镇' where ideal_title='济源市思礼镇'; update article set ideal_title='王屋镇' where ideal_title='济源市王屋镇'; update article set ideal_title='下冶镇' where ideal_title='济源市下冶镇'; update article set ideal_title='九峰乡' where ideal_title='东湖开发区九峰乡'; update article set ideal_title='玉阳街道' where ideal_title='当阳市玉阳街道'; update article set ideal_title='坝陵街道' where ideal_title='当阳市坝陵街道'; update article set ideal_title='玉泉街道' where ideal_title='当阳市玉泉街道'; update article set ideal_title='两河镇' where ideal_title='当阳市两河镇'; update article set ideal_title='河溶镇' where ideal_title='当阳市河溶镇'; update article set ideal_title='育溪镇' where ideal_title='当阳市育溪镇'; update article set ideal_title='庙前镇' where ideal_title='当阳市庙前镇'; update article set ideal_title='王店镇' where ideal_title='当阳市王店镇'; update article set ideal_title='半月镇' where ideal_title='当阳市半月镇'; update article set ideal_title='草埠湖镇' where ideal_title='当阳市草埠湖镇'; update article set ideal_title='朋兴乡' where ideal_title='孝南区朋兴乡'; update article set ideal_title='卧龙乡' where ideal_title='孝南区卧龙乡'; update article set ideal_title='闵集乡' where ideal_title='孝南区闵集乡'; update article set ideal_title='滩营乡' where ideal_title='防城区滩营乡'; update article set ideal_title='黄闸湾乡' where ideal_title='玉门市黄闸湾乡'; update article set ideal_title='大河乡' where ideal_title='红寺堡开发区大河乡'; update article set ideal_title='南川乡' where ideal_title='红寺堡开发区南川乡'; update article set ideal_title='西尼尔镇' where ideal_title='库尔勒市西尼尔镇'; update article set ideal_title='兰干乡' where ideal_title='库尔勒市兰干乡'; update article set ideal_title='托布力其乡' where ideal_title='库尔勒市托布力其乡';
update article set nocreate=1 where ideal_title regexp '(自治区|省)直辖县级行政区划' and code3='00'; update article set nocreate=1 where ideal_title like '市辖区' and code3='00'; -- 只更新了直辖市中的“市辖区”,其他的还有大量“市辖区”,不知道是什么状况 update article set nocreate=1 where ideal_title like '县' and code3='00'; -- 已经是全部的“县”了
update article set nocreate=1 where ideal_title = '伊宁市边境经济合作区管委会'; -- 是否应该创建为“伊宁市边境经济合作区”? update article set nocreate=1 where ideal_title = '湖滨社区行政事务管理中心'; update article set nocreate=1 where ideal_title = '淮河社区行政事务管理中心'; update article set nocreate=1 where ideal_title = '南黎办事处筹备组'; update article set nocreate=1 where ideal_title = '中心镇建设管理办公室'; update article set ideal_title = replace(ideal_title, '长白山保护开发区管委会', '') where ideal_title like '长白山保护开发区管委会%区';
update article set ideal_title=replace(ideal_title,'街道办事处','街道') where ideal_title like '%街道办事处' and code5='000' and code4<'400';
update article set ideal_title = replace(ideal_title, '大理经济开发区', '') where ideal_title like '大理经济开发区%办事处'; update article set ideal_title = replace(ideal_title, '大亚湾', '') where ideal_title like '大亚湾%办事处'; -- 这个顺便改了一个类似乡级的“大亚湾西区办事处” update article set ideal_title = replace(ideal_title, '孝南区', '') where ideal_title like '孝南区%办事处';
update article set nocreate=1 where ideal_title = '曲阳办事处筹备组'; update article set ideal_title = replace(ideal_title, '满洲里市', '') where ideal_title like '满洲里市第%办事处';
update article set ideal_title='郧县经济开发区' where ideal_title like '经济开发区(茶店镇)'; update article set ideal_title='广东铝厂社区居民居委会' where ideal_title like '董塘镇广东铝厂社区居民居委会';
update article set ideal_title=replace(ideal_title,'新巴尔虎右旗','') where ideal_title='新巴尔虎右旗呼伦镇'; update article set ideal_title=replace(ideal_title,'察哈尔右翼后旗','') where ideal_title='察哈尔右翼后旗土牧尔台镇'; update article set ideal_title=replace(ideal_title,'察哈尔右翼后旗','') where ideal_title='察哈尔右翼后旗红格尔图镇'; update article set ideal_title=replace(ideal_title,'察哈尔右翼后旗','') where ideal_title='察哈尔右翼后旗贲红镇'; update article set ideal_title=replace(ideal_title,'察哈尔右翼后旗','') where ideal_title='察哈尔右翼后旗当郎忽洞苏木'; update article set ideal_title=replace(ideal_title,'察哈尔右翼后旗','') where ideal_title='察哈尔右翼后旗乌兰哈达苏木'; update article set ideal_title=replace(ideal_title,'察哈尔右翼后旗','') where ideal_title='察哈尔右翼后旗锡勒乡'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗乌兰花镇'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗吉生太镇'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗库伦图镇'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗供济堂镇'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗白音朝克图镇'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗红格尔苏木'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗江岸苏木'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗查干补力格苏木'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗脑木更苏木'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗东八号乡'; update article set ideal_title=replace(ideal_title,'四子王旗','') where ideal_title='四子王旗忽鸡图乡'; update article set ideal_title=replace(ideal_title,'额济纳旗','') where ideal_title='额济纳旗东风镇'; update article set ideal_title=replace(ideal_title,'额济纳旗','') where ideal_title='额济纳旗赛汉陶来苏木乡'; update article set ideal_title=replace(ideal_title,'额济纳旗','') where ideal_title='额济纳旗马鬃山苏木乡'; update article set ideal_title=replace(ideal_title,'额济纳旗','') where ideal_title='额济纳旗苏泊淖尔苏木乡'; update article set ideal_title=replace(ideal_title,'当阳市','') where ideal_title='当阳市玉阳街道'; update article set ideal_title=replace(ideal_title,'当阳市','') where ideal_title='当阳市坝陵街道'; update article set ideal_title=replace(ideal_title,'当阳市','') where ideal_title='当阳市玉泉街道'; update article set ideal_title=replace(ideal_title,'当阳市','') where ideal_title='当阳市两河镇'; update article set ideal_title=replace(ideal_title,'当阳市','') where ideal_title='当阳市河溶镇'; update article set ideal_title=replace(ideal_title,'当阳市','') where ideal_title='当阳市育溪镇';
update article set ideal_title=replace(ideal_title,'街道办','') where code5='000' and ideal_title like '%街道办'; update article set ideal_title=replace(ideal_title,'街道办事','') where code5='000' and ideal_title like '%街道办事';
update article set ideal_title='允景洪街道' where code1='53' and code2='28' and code3='01' and code4='001' and code5='000'; update article set ideal_title='光明路街道' where code1='37' and code2='04' and code3='02' and code4='006' and code5='000'; update article set ideal_title='文化路街道' where code1='37' and code2='04' and code3='02' and code4='004' and code5='000'; update article set ideal_title='东升街道' where code1='51' and code2='01' and code3='22' and code4='001' and code5='000'; update article set ideal_title='东镇街道' where code1='44' and code2='09' and code3='83' and code4='001' and code5='000'; update article set ideal_title='中和街道' where code1='51' and code2='01' and code3='22' and code4='004' and code5='000'; update article set ideal_title='乌东路街道' where code1='65' and code2='40' and code3='03' and code4='002' and code5='000'; update article set ideal_title='会城街道' where code1='44' and code2='07' and code3='05' and code4='001' and code5='000'; update article set ideal_title='佃户屯街道' where code1='37' and code2='17' and code3='02' and code4='008' and code5='000'; update article set ideal_title='前山街道' where code1='44' and code2='04' and code3='02' and code4='003' and code5='000'; update article set ideal_title='华阳镇街道' where code1='51' and code2='01' and code3='22' and code4='003' and code5='000'; update article set ideal_title='古楚街道' where code1='32' and code2='13' and code3='02' and code4='051' and code5='000'; update article set ideal_title='吉大街道' where code1='44' and code2='04' and code3='02' and code4='004' and code5='000'; update article set ideal_title='吴林街道' where code1='37' and code2='04' and code3='04' and code4='002' and code5='000'; update article set ideal_title='团结路街道' where code1='65' and code2='40' and code3='03' and code4='001' and code5='000'; update article set ideal_title='国兴街道' where code1='46' and code2='01' and code3='07' and code4='001' and code5='000'; update article set ideal_title='坛山街道' where code1='37' and code2='04' and code3='04' and code4='001' and code5='000'; update article set ideal_title='城北街道' where code1='44' and code2='08' and code3='81' and code4='003' and code5='000'; update article set ideal_title='城南街道' where code1='44' and code2='08' and code3='81' and code4='002' and code5='000'; update article set ideal_title='官渡街道' where code1='44' and code2='09' and code3='02' and code4='006' and code5='000'; update article set ideal_title='小溪塔街道' where code1='42' and code2='05' and code3='06' and code4='001' and code5='000'; update article set ideal_title='徐城街道' where code1='44' and code2='08' and code3='25' and code4='001' and code5='000'; update article set ideal_title='拱北街道' where code1='44' and code2='04' and code3='02' and code4='005' and code5='000'; update article set ideal_title='新华街道' where code1='44' and code2='09' and code3='02' and code4='005' and code5='000'; update article set ideal_title='新城街道' where code1='44' and code2='08' and code3='82' and code4='003' and code5='000'; update article set ideal_title='新窑街道' where code1='62' and code2='08' and code3='23' and code4='400' and code5='000'; update article set ideal_title='梅华街道' where code1='44' and code2='04' and code3='02' and code4='002' and code5='000'; update article set ideal_title='河东区街道' where code1='46' and code2='02' and code3='01' and code4='406' and code5='000'; update article set ideal_title='河东街道' where code1='44' and code2='09' and code3='02' and code4='003' and code5='000'; update article set ideal_title='河西区街道' where code1='46' and code2='02' and code3='01' and code4='405' and code5='000'; update article set ideal_title='河西街道' where code1='44' and code2='09' and code3='02' and code4='002' and code5='000'; update article set ideal_title='泉口街道' where code1='42' and code2='08' and code3='02' and code4='002' and code5='000'; update article set ideal_title='海秀街道' where code1='46' and code2='01' and code3='05' and code4='002' and code5='000'; update article set ideal_title='湾仔街道' where code1='44' and code2='04' and code3='02' and code4='008' and code5='000'; update article set ideal_title='火车站街道' where code1='65' and code2='40' and code3='03' and code4='005' and code5='000'; update article set ideal_title='狮山街道' where code1='44' and code2='04' and code3='02' and code4='007' and code5='000'; update article set ideal_title='站前街道' where code1='44' and code2='09' and code3='02' and code4='007' and code5='000'; update article set ideal_title='红旗街道' where code1='44' and code2='09' and code3='02' and code4='001' and code5='000'; update article set ideal_title='罗州街道' where code1='44' and code2='08' and code3='81' and code4='001' and code5='000'; update article set ideal_title='翠香街道' where code1='44' and code2='04' and code3='02' and code4='001' and code5='000'; update article set ideal_title='西湖街道' where code1='44' and code2='08' and code3='82' and code4='002' and code5='000'; update article set ideal_title='西湾子街道' where code1='13' and code2='07' and code3='33' and code4='001' and code5='000'; update article set ideal_title='西航港街道' where code1='51' and code2='01' and code3='22' and code4='002' and code5='000'; update article set ideal_title='锦屏街道' where code1='62' and code2='08' and code3='23' and code4='001' and code5='000'; update article set ideal_title='雷城街道' where code1='44' and code2='08' and code3='82' and code4='001' and code5='000'; update article set ideal_title='露天矿街道' where code1='44' and code2='09' and code3='02' and code4='004' and code5='000'; update article set ideal_title='靖城街道' where code1='32' and code2='12' and code3='82' and code4='001' and code5='000'; update article set ideal_title='香湾街道' where code1='44' and code2='04' and code3='02' and code4='006' and code5='000'; update article set ideal_title='黄河街道' where code1='32' and code2='13' and code3='02' and code4='050' and code5='000'; update article set ideal_title='龙泉街道' where code1='42' and code2='08' and code3='02' and code4='001' and code5='000';