廣告廣告
  加入我的最愛 設為首頁 風格修改
首頁 首尾
 手機版   訂閱   地圖  簡體 
您是第 6260 個閱讀者
 
發表文章 發表投票 回覆文章
  可列印版   加為IE收藏   收藏主題   上一主題 | 下一主題   
笑笑 會員卡 葫蘆墩家族
個人文章 個人相簿 個人日記 個人地圖
發文大師獎
頭銜:    
風雲人物
級別: 風雲人物 該用戶目前不上站
推文 x137 鮮花 x523
分享: 轉寄此文章 Facebook Plurk Twitter 複製連結到剪貼簿 轉換為繁體 轉換為簡體 載入圖片
推文 x0
[SQL][教學] [轉貼]新五都地址修正SQL語法
最近剛好五都選舉完,要修訂所有的地址資料,整理了以下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
附件中是我改法,有點笨


本帖包含附件
txt 五都改地址.txt   (2022-06-09 14:17 / 33 KB)   下載次數:25



每天大笑三聲,可以讓你更長壽哦...^^
獻花 x0 回到頂端 [樓 主] From:台灣新世紀資通 | Posted:2011-02-16 13:02 |

首頁  發表文章 發表投票 回覆文章
Powered by PHPWind v1.3.6
Copyright © 2003-04 PHPWind
Processed in 0.047977 second(s),query:15 Gzip disabled
本站由 瀛睿律師事務所 擔任常年法律顧問 | 免責聲明 | 本網站已依台灣網站內容分級規定處理 | 連絡我們 | 訪客留言