最近刚好五都选举完，要修订所有的地址资料，整理了以下SQL语法
若有人需要用到~ 刚好可以拿去用唷! (有顺序性)

基本上就是依据

台中县（市）、台南县（市）及高雄县（市）等改制为直辖市。

改制后，仅将原台北县、台中县、台南县及高雄县之「乡、镇、市」改为「区」，「村」改为「里」，街路名称维持不变。


update MYTABLE set ADDRESS = replace(ADDRESS, '龟港村','龟港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龟洞村','龟洞里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龟壳村','龟壳里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龟丹村','龟丹里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙船村','龙船里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙兴村','龙兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙源村','龙源里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙湖村','龙湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙津村','龙津里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙山村','龙山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '鹿田村','鹿田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '鹿埔村','鹿埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '盐田村','盐田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '盐埕村','盐埕里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '凤雄村','凤雄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '鲲鯓村','鲲鯓里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '鲲溟村','鲲溟里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '鲲江村','鲲江里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '高原村','高原里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '高中村','高中里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '马鸣村','马鸣里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '香洋村','香洋里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '头社村','头社里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶盐村','顶盐里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶长村','顶长里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶罟村','顶罟里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶福村','顶福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶山村','顶山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶安村','顶安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '顶厝村','顶厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '青旗村','青旗里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '青山村','青山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '双春村','双春里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '集来村','集来里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '隆盛村','隆盛里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '隆田村','隆田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '隆本村','隆本里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '陆一村','陆一里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '阿莲村','阿莲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '阿柔村','阿柔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '关庙村','关庙里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '关山村','关山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '长沙村','长沙里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '长荣村','长荣里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '长安村','长安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '长坑村','长坑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '铁山村','铁山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '锦湖村','锦湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '金竹村','金竹里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '金砂村','金砂里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '金星村','金星里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '金山村','金山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '重溪村','重溪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '醒村','醒里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '部仔村','部仔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '达观村','达观里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '过港村','过港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '逸贤村','逸贤里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '辜厝村','辜厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '赤西村','赤西里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '赤东村','赤东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '赤崁村','赤崁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '贺建村','贺建里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '贸商村','贸商里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '丰里村','丰里里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '丰华村','丰华里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '丰田村','丰田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '丰德村','丰德里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '许厝村','许厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '讯塘村','讯塘里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '角宿村','角宿里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '观亭村','观亭里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西连村','西连里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西华村','西华里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西燕村','西燕里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西港村','西港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西林村','西林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西德村','西德里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西庄村','西庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西寮村','西寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西安村','西安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西埔村','西埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '西和村','西和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '苏林村','苏林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '苏厝村','苏厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '蔗部村','蔗部里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '叶厝村','叶厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '万顺村','万顺里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '万兴村','万兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '万福村','万福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '万山村','万山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '万安村','万安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '万 村','万 里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '菁湖村','菁湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '菁寮村','菁寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '菁埔村','菁埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '荖阡村','荖阡里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '荖浓村','荖浓里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '草山村','草山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '茅港村','茅港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '茄苳村','茄苳里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '茄典村','茄典里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '茂林村','茂林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '苓和村','苓和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '芋寮村','芋寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '旧社村','旧社里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '旧港村','旧港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '旧城村','旧城里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '兴糖村','兴糖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '自由村','自由里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '联合村','联合里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '圣贤村','圣贤里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '义里村','义里里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '义宝村','义宝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '义合村','义合里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '维新村','维新里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '红厝村','红厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '糠榔村','糠榔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '粗堀村','粗堀里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '米仓村','米仓里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '笃农村','笃农里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '笃加村','笃加里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '管寮村','管寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '笔秀村','笔秀里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹港村','竹港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹桥村','竹桥里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹林村','竹林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹新村','竹新里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹坑村','竹坑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹围村','竹围里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '竹南村','竹南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '科里村','科里里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '礼蚵村','礼蚵里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '福兴村','福兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '福德村','福德里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '福山村','福山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '福安村','福安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '福住村','福住里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '神农村','神农里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '神洲村','神洲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '神冈村','神冈里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '社子村','社子里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '社内村','社内里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '磺滨村','磺滨里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石碇村','石碇里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石湖村','石湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石槽村','石槽里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石林村','石林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石冈村','石冈里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石安村','石安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石城村','石城里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '石坑村','石坑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '睦光村','睦光里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '看西村','看西里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '看东村','看东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '看坪村','看坪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '眉山村','眉山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '白云村','白云里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '白树村','白树里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '甲南村','甲南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '甲北村','甲北里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '甲中村','甲中里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '田尾村','田尾里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '田寮村','田寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '田厝村','田厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '田中村','田中里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '琼林村','琼林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '环湖村','环湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '瑞平村','瑞平里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '瑞山村','瑞山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '瑞井村','瑞井里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '王爷村','王爷里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉田村','玉田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉港村','玉港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉桂村','玉桂里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉成村','玉成里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉库村','玉库里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉峰村','玉峰里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉山村','玉山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '牛埔村','牛埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '营西村','营西里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '营东村','营东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '营前村','营前里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '乌树村','乌树里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '乌林村','乌林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '乌涂村','乌涂里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '乌来村','乌来里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '湾丘村','湾丘里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '澄山村','澄山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '潭顶村','潭顶里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '潭边村','潭边里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '漯底村','漯底里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '渔光村','渔光里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '溪南村','溪南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '沟坪村','沟坪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '湖山村','湖山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '湖南村','湖南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '湖北村','湖北里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '湖内村','湖内里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '港东村','港东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '港后村','港后里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '港尾村','港尾里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '港口村','港口里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '港南村','港南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '渡头村','渡头里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '清莲村','清莲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '深水村','深水里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '深坑村','深坑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '海山村','海山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '海尾村','海尾里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '海寮村','海寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '海墘村','海墘里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '海埔村','海埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '泰安村','泰安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '沙田村','沙田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '沙仑村','沙仑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永隆村','永隆里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永丰村','永丰里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永华村','永华里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永兴村','永兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永乐村','永乐里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永就村','永就里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永富村','永富里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永定村','永定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永安村','永安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '永吉村','永吉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '水云村','水云里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '水林村','水林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '水寮村','水寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '水安村','水安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '民权村','民权里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '民族村','民族里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '归仁村','归仁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '武东村','武东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '檨脚村','檨脚里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '檨林村','檨林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '横山村','横山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '桥头村','桥头里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '桥南村','桥南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '树林村','树林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '樟山村','樟山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '乐业村','乐业里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '荣和村','荣和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '楠坑村','楠坑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '枫林村','枫林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梨山村','梨山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梓义村','梓义里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梓平村','梓平里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梓和村','梓和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梓信村','梓信里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梅山村','梅山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '梅子村','梅子里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '桃源村','桃源里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '果毅村','果毅里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '林安村','林安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '林口村','林口里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '松雅村','松雅里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '松脚村','松脚里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东兴村','东兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东燕村','东燕里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东河村','东河里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东正村','东正里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东林村','东林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东升村','东升里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东庄村','东庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东山村','东山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东安村','东安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东壁村','东壁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东埔村','东埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东和村','东和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东原村','东原里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东势村','东势里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '东中村','东中里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '杉林村','杉林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '本乡村','本乡里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '木梓村','木梓里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '木栅村','木栅里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '望明村','望明里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '望古村','望古里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '月美村','月美里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '月眉村','月眉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '月湖村','月湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '曲溪村','曲溪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '智蚵村','智蚵里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '明和村','明和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '升高村','升高里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '旭山村','旭山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新达村','新达里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新庄村','新庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新兴村','新兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新社村','新社里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新发村','新发里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新田村','新田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新港村','新港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新复村','新复里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新庄村','新庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新市村','新市里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新寮村','新寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新威村','新威里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新埔村','新埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新嘉村','新嘉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新吉村','新吉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '新光村','新光里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '文贤村','文贤里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '文武村','文武里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '文安村','文安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '拔林村','拔林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '成功村','成功里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '慈安村','慈安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '忠兴村','忠兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '忠治村','忠治里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '德兴村','德兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '德松村','德松里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '复兴村','复兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '复盛村','复盛里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '复安村','复安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后乡村','后乡里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后街村','后街里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后港村','后港里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后市村','后市里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后壁村','后壁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后xx村','后xx里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '彭山村','彭山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '弥靖村','弥靖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '弥陀村','弥陀里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '弥寿村','弥寿里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '弥仁村','弥仁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '建山村','建山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '广福村','广福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '广山村','广山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '店子村','店子里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '庄后村','庄后里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '平阳村','平阳里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '平等村','平等里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '平沙村','平沙里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '平安村','平安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '布袋村','布袋里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '左镇村','左镇里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '岭南村','岭南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仑顶村','仑顶里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '岗山村','岗山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '昆山村','昆山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '崎顶村','崎顶里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '崎漏村','崎漏里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '崇德村','崇德里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '崁顶村','崁顶里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '峰山村','峰山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '冈林村','冈林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '山西村','山西里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '山脚村','山脚里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '山皮村','山皮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '山上村','山上里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '层林村','层林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '尖山村','尖山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '小林村','小林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '小仑村','小仑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '将贵村','将贵里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '将富村','将富里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '宝隆村','宝隆里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '宝山村','宝山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '密枝村','密枝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '官田村','官田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '安招村','安招里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '安定村','安定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '安厝村','安厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '安加村','安加里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '宅内村','宅内里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '孝义村','孝义里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '妈庙村','妈庙里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '太爷村','太爷里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '太康村','太康里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '太平村','太平里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '天轮村','天轮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大农村','大农里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大舍村','大舍里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大社村','大社里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大甲村','大甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大田村','大田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大营村','大营里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大潭村','大潭里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大湖村','大湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大洲村','大洲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大津村','大津里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大林村','大林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大东村','大东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大庙村','大庙里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大崎村','大崎里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大崁村','大崁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大屯村','大屯里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大寮村','大寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大客村','大客里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大定村','大定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大埤村','大埤里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大埕村','大埕里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大坪村','大坪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大同村','大同里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大南村','大南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '大丘村','大丘里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '多纳村','多纳里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '士林村','士林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '墩西村','墩西里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '墩东村','墩东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '墩南村','墩南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '墩北村','墩北里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '墨林村','墨林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '埤头村','埤头里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '城内村','城内里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '坪林村','坪林里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '坑口村','坑口里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '圳堵村','圳堵里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '圳前村','圳前里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '土牛村','土牛里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '土沟村','土沟里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '土库村','土库里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '土崎村','土崎里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '土垄村','土垄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '土城村','土城里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉赐村','嘉赐里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉福村','嘉福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉田村','嘉田里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉泰村','嘉泰里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉民村','嘉民里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉乐村','嘉乐里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉昌村','嘉昌里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉宝村','嘉宝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉定村','嘉定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉安村','嘉安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉吉村','嘉吉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '嘉南村','嘉南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '和莲村','和莲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '和盛村','和盛里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '和安村','和安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '和协村','和协里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '后里村','后里里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '吉定村','吉定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '古亭村','古亭里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '厚里村','厚里里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '博爱村','博爱里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南部村','南部里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南莲村','南莲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南花村','南花里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南兴村','南兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南燕村','南燕里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南溪村','南溪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南海村','南海里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南洲村','南洲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南柳村','南柳里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南庄村','南庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南寮村','南寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南安村','南安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南化村','南化里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南势村','南势里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '南保村','南保里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '十份村','十份里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北门村','北门里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北花村','北花里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北柳村','北柳里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北庄村','北庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北平村','北平里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北寮村','北寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北埔村','北埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '北势村','北势里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '勤和村','勤和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '刘家村','刘家里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '刘厝村','刘厝里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '六龟村','六龟里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '六甲村','六甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '六嘉村','六嘉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '六分村','六分里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '公馆村','公馆里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '八翁村','八翁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '八甲村','八甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内门村','内门里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内郭村','内郭里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内丰村','内丰里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内兴村','内兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内江村','内江里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内东村','内东里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内庄村','内庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '内南村','内南里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '光兴村','光兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '光福村','光福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '光明村','光明里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '光定村','光定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '光和村','光和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '信贤村','信贤里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '信蚵村','信蚵里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '保西村','保西里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '保源村','保源里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '保宁村','保宁里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '保定村','保定里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '保吉村','保吉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '侯伯村','侯伯里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仕隆村','仕隆里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仕丰村','仕丰里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仕安村','仕安里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仕和村','仕和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仁里村','仁里里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仁爱村','仁爱里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仁德村','仁德里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '仁和村','仁和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '人和村','人和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '五福村','五福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '五甲村','五甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '二镇村','二镇里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '二行村','二行里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '二甲村','二甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '二溪村','二溪里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '二寮村','二寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '九房村','九房里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中路村','中路里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中贤村','中贤里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中兴村','中兴里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中程村','中程里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中社村','中社里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中生村','中生里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中营村','中营里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中湖村','中湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中洲村','中洲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中沙村','中沙里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中民村','中民里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中正村','中正里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中枢村','中枢里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中荣村','中荣里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中庄村','中庄里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中仑村','中仑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中崎村','中崎里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中山村','中山里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中寮村','中寮里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中埔村','中埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中坑村','中坑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '中和村','中和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '下罟村','下罟里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '下福村','下福里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '下营村','下营里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '下湖村','下湖里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '上德村','上德里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '上平村','上平里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '上仑村','上仑里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三角村','三角里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三舍村','三舍里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三股村','三股里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三甲村','三甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三荣村','三荣里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三平村','三平里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三埔村','三埔里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三和村','三和里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三吉村','三吉里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '三光村','三光里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '七股村','七股里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '七甲村','七甲里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');
update MYTABLE set ADDRESS = replace(ADDRESS, '七星村','七星里') where ADDRESS like ('%台北县%' OR '%台中县%' OR '%台南县%' OR '%高雄县%');

update MYTABLE set ADDRESS = replace(ADDRESS, '万里乡','万里区');
update MYTABLE set ADDRESS = replace(ADDRESS, '金山乡','金山区');
update MYTABLE set ADDRESS = replace(ADDRESS, '板桥市','板桥区');
update MYTABLE set ADDRESS = replace(ADDRESS, '汐止市','汐止区');
update MYTABLE set ADDRESS = replace(ADDRESS, '深坑乡','深坑区');
update MYTABLE set ADDRESS = replace(ADDRESS, '石碇乡','石碇区');
update MYTABLE set ADDRESS = replace(ADDRESS, '瑞芳镇','瑞芳区');
update MYTABLE set ADDRESS = replace(ADDRESS, '平溪乡','平溪区');
update MYTABLE set ADDRESS = replace(ADDRESS, '双溪乡','双溪区');
update MYTABLE set ADDRESS = replace(ADDRESS, '贡寮乡','贡寮区');
update MYTABLE set ADDRESS = replace(ADDRESS, '新店市','新店区');
update MYTABLE set ADDRESS = replace(ADDRESS, '坪林乡','坪林区');
update MYTABLE set ADDRESS = replace(ADDRESS, '乌来乡','乌来区');
update MYTABLE set ADDRESS = replace(ADDRESS, '永和市','永和区');
update MYTABLE set ADDRESS = replace(ADDRESS, '中和市','中和区');
update MYTABLE set ADDRESS = replace(ADDRESS, '土城市','土城区');
update MYTABLE set ADDRESS = replace(ADDRESS, '三峡镇','三峡区');
update MYTABLE set ADDRESS = replace(ADDRESS, '树林市','树林区');
update MYTABLE set ADDRESS = replace(ADDRESS, '莺歌镇','莺歌区');
update MYTABLE set ADDRESS = replace(ADDRESS, '三重市','三重区');
update MYTABLE set ADDRESS = replace(ADDRESS, '新庄市','新庄区');
update MYTABLE set ADDRESS = replace(ADDRESS, '泰山乡','泰山区');
update MYTABLE set ADDRESS = replace(ADDRESS, '林口乡','林口区');
update MYTABLE set ADDRESS = replace(ADDRESS, '芦洲市','芦洲区');
update MYTABLE set ADDRESS = replace(ADDRESS, '五股乡','五股区');
update MYTABLE set ADDRESS = replace(ADDRESS, '八里乡','八里区');
update MYTABLE set ADDRESS = replace(ADDRESS, '淡水镇','淡水区');
update MYTABLE set ADDRESS = replace(ADDRESS, '三芝乡','三芝区');
update MYTABLE set ADDRESS = replace(ADDRESS, '石门乡','石门区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大雅乡','大雅区');
update MYTABLE set ADDRESS = replace(ADDRESS, '太平市','太平区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大里市','大里区');
update MYTABLE set ADDRESS = replace(ADDRESS, '雾峰乡','雾峰区');
update MYTABLE set ADDRESS = replace(ADDRESS, '乌日乡','乌日区');
update MYTABLE set ADDRESS = replace(ADDRESS, '丰原市','丰原区');
update MYTABLE set ADDRESS = replace(ADDRESS, '后里乡','后里区');
update MYTABLE set ADDRESS = replace(ADDRESS, '石冈乡','石冈区');
update MYTABLE set ADDRESS = replace(ADDRESS, '东势镇','东势区');
update MYTABLE set ADDRESS = replace(ADDRESS, '和平乡','和平区');
update MYTABLE set ADDRESS = replace(ADDRESS, '新社乡','新社区');
update MYTABLE set ADDRESS = replace(ADDRESS, '潭子乡','潭子区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大雅乡','大雅区');
update MYTABLE set ADDRESS = replace(ADDRESS, '神冈乡','神冈区');
update MYTABLE set ADDRESS = replace(ADDRESS, '雾峰乡','雾峰区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大肚乡','大肚区');
update MYTABLE set ADDRESS = replace(ADDRESS, '沙鹿镇','沙鹿区');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙井乡','龙井区');
update MYTABLE set ADDRESS = replace(ADDRESS, '梧栖镇','梧栖区');
update MYTABLE set ADDRESS = replace(ADDRESS, '清水镇','清水区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大甲镇','大甲区');
update MYTABLE set ADDRESS = replace(ADDRESS, '外埔乡','外埔区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大安乡','大安区');
update MYTABLE set ADDRESS = replace(ADDRESS, '永康市','永康区');
update MYTABLE set ADDRESS = replace(ADDRESS, '归仁乡','归仁区');
update MYTABLE set ADDRESS = replace(ADDRESS, '新化镇','新化区');
update MYTABLE set ADDRESS = replace(ADDRESS, '左镇乡','左镇区');
update MYTABLE set ADDRESS = replace(ADDRESS, '玉井乡','玉井区');
update MYTABLE set ADDRESS = replace(ADDRESS, '楠西乡','楠西区');
update MYTABLE set ADDRESS = replace(ADDRESS, '南化乡','南化区');
update MYTABLE set ADDRESS = replace(ADDRESS, '仁德乡','仁德区');
update MYTABLE set ADDRESS = replace(ADDRESS, '关庙乡','关庙区');
update MYTABLE set ADDRESS = replace(ADDRESS, '龙崎乡','龙崎区');
update MYTABLE set ADDRESS = replace(ADDRESS, '官田乡','官田区');
update MYTABLE set ADDRESS = replace(ADDRESS, '麻豆镇','麻豆区');
update MYTABLE set ADDRESS = replace(ADDRESS, '佳里镇','佳里区');
update MYTABLE set ADDRESS = replace(ADDRESS, '西港乡','西港区');
update MYTABLE set ADDRESS = replace(ADDRESS, '七股乡','七股区');
update MYTABLE set ADDRESS = replace(ADDRESS, '将军乡','将军区');
update MYTABLE set ADDRESS = replace(ADDRESS, '学甲镇','学甲区');
update MYTABLE set ADDRESS = replace(ADDRESS, '北门乡','北门区');
update MYTABLE set ADDRESS = replace(ADDRESS, '新营市','新营区');
update MYTABLE set ADDRESS = replace(ADDRESS, '后壁乡','后壁区');
update MYTABLE set ADDRESS = replace(ADDRESS, '白河镇','白河区');
update MYTABLE set ADDRESS = replace(ADDRESS, '东山乡','东山区');
update MYTABLE set ADDRESS = replace(ADDRESS, '六甲乡','六甲区');
update MYTABLE set ADDRESS = replace(ADDRESS, '下营乡','下营区');
update MYTABLE set ADDRESS = replace(ADDRESS, '柳营乡','柳营区');
update MYTABLE set ADDRESS = replace(ADDRESS, '盐水镇','盐水区');
update MYTABLE set ADDRESS = replace(ADDRESS, '善化镇','善化区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大内乡','大内区');
update MYTABLE set ADDRESS = replace(ADDRESS, '山上乡','山上区');
update MYTABLE set ADDRESS = replace(ADDRESS, '新市乡','新市区');
update MYTABLE set ADDRESS = replace(ADDRESS, '安定乡','安定区');
update MYTABLE set ADDRESS = replace(ADDRESS, '仁武乡','仁武区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大社乡','大社区');
update MYTABLE set ADDRESS = replace(ADDRESS, '冈山镇','冈山区');
update MYTABLE set ADDRESS = replace(ADDRESS, '路竹乡','路竹区');
update MYTABLE set ADDRESS = replace(ADDRESS, '阿莲乡','阿莲区');
update MYTABLE set ADDRESS = replace(ADDRESS, '田寮乡','田寮区');
update MYTABLE set ADDRESS = replace(ADDRESS, '燕巢乡','燕巢区');
update MYTABLE set ADDRESS = replace(ADDRESS, '桥头乡','桥头区');
update MYTABLE set ADDRESS = replace(ADDRESS, '梓官乡','梓官区');
update MYTABLE set ADDRESS = replace(ADDRESS, '弥陀乡','弥陀区');
update MYTABLE set ADDRESS = replace(ADDRESS, '永安乡','永安区');
update MYTABLE set ADDRESS = replace(ADDRESS, '湖内乡','湖内区');
update MYTABLE set ADDRESS = replace(ADDRESS, '凤山市','凤山区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大寮乡','大寮区');
update MYTABLE set ADDRESS = replace(ADDRESS, '林园乡','林园区');
update MYTABLE set ADDRESS = replace(ADDRESS, '鸟松乡','鸟松区');
update MYTABLE set ADDRESS = replace(ADDRESS, '九曲堂','九曲区');
update MYTABLE set ADDRESS = replace(ADDRESS, '大树乡','大树区');
update MYTABLE set ADDRESS = replace(ADDRESS, '旗山镇','旗山区');
update MYTABLE set ADDRESS = replace(ADDRESS, '美浓镇','美浓区');
update MYTABLE set ADDRESS = replace(ADDRESS, '六龟乡','六龟区');
update MYTABLE set ADDRESS = replace(ADDRESS, '内门乡','内门区');
update MYTABLE set ADDRESS = replace(ADDRESS, '杉林乡','杉林区');
update MYTABLE set ADDRESS = replace(ADDRESS, '甲仙乡','甲仙区');
update MYTABLE set ADDRESS = replace(ADDRESS, '桃源乡','桃源区');
update MYTABLE set ADDRESS = replace(ADDRESS, '那玛夏乡','那玛夏区');
update MYTABLE set ADDRESS = replace(ADDRESS, '茂林乡','茂林区');
update MYTABLE set ADDRESS = replace(ADDRESS, '茄萣乡','茄萣区');

update MYTABLE set ADDRESS = replace(ADDRESS, '台北县','新北市');
update MYTABLE set ADDRESS = replace(ADDRESS, '台中县','台中市');
update MYTABLE set ADDRESS = replace(ADDRESS, '台南县','台南市');
update MYTABLE set ADDRESS = replace(ADDRESS, '高雄县','高雄市');


转贴自 http://ppt.cc...p=41

其实我自己也有写一个
只是改完才发现这个网站的..XD
附件中是我改法，有点笨