Home > 未分類

未分類 Archive

法律小常識 – 個人資料保護

近日收到台北市警局的公文,來函要特定短網址的建立者 IP 資料,基於保護
個人資料的立場,我們研究了一下相關法令,根據刑事訴訟法第 122 條及第
128 條,警察如因偵查需要,必須向第三方調閱電磁紀錄,是需要向法院聲請
搜索票的,並不是這樣隨便發一紙公文,我們就得照辦。

基於個人資料保護的立場,我們必須依法行事不予提供,當然網友在發表謾罵
性言論時,也必須考量是否符合言論自由範圍,以免產生訴訟糾紛。

刑事訴訟法
第 122 條
對於被告或犯罪嫌疑人之身體、物件、電磁紀錄及住宅或其他處所,必要
時得搜索之。
對於第三人之身體、物件、電磁紀錄及住宅或其他處所,以有相當理由可
信為被告或犯罪嫌疑人或應扣押之物或電磁紀錄存在時為限,得搜索
之。

第 128 條
搜索,應用搜索票。
搜索票,應記載下列事項:
一、案由。
二、應搜索之被告、犯罪嫌疑人或應扣押之物。但被告或犯罪嫌疑人不明
時,得不予記載。
三、應加搜索之處所、身體、物件或電磁紀錄。
四、有效期間,逾期不得執行搜索及搜索後應將搜索票交還之意旨。
搜索票,由法官簽名。法官並得於搜索票上,對執行人員為適當之指示。
核發搜索票之程序,不公開之。

第 229 條
下列各員,於其管轄區域內為司法警察官,有協助檢察官偵查犯罪之職權

一、警政署署長、警察局局長或警察總隊總隊長。
二、憲兵隊長官。
三、依法令關於特定事項,得行相當於前二款司法警察官之職權者。
前項司法警察官,應將調查之結果,移送該管檢察官;如接受被拘提或逮
捕之犯罪嫌疑人,除有特別規定外,應解送該管檢察官。但檢察官命其解
送者,應即解送。
被告或犯罪嫌疑人未經拘提或逮捕者,不得解送。

第 230 條
下列各員為司法警察官,應受檢察官之指揮,偵查犯罪:
一、警察官長。
二、憲兵隊官長、士官。
三、依法令關於特定事項,得行司法警察官之職權者。
前項司法警察官知有犯罪嫌疑者,應即開始調查,並將調查之情形報告該
管檢察官及前條之司法警察官。
實施前項調查有必要時,得封鎖犯罪現場,並為即時之勘察。

PPT.cc 的近況

很久很久沒有分享 PPT.cc 的近況了,Blog 也被大量的 spam 給入侵,花了好一會功夫才全部清完,但我們仍一直默默運作著,只是兩位站長白天各自有各自的工作,只能利用半夜空閒時間來處理所有 PPT.cc 的雜務,每天用著工人智慧來處理不良圖片,因為 30cm 真的太嚇人了,這些不適合闔家觀賞的,這是我們應盡的社會責任。

從 2008 年到現在,即將滿 4 年了,這個站帶給我們成長很多,也讓我們面臨很多的挑戰,我想任何人都不會想要用一個點下去很慢,或者完全開步出來的服務,大家在銀幕前等待的心情,對我們來說是無比錐心的,好在我們還是挺了過來,希望走著走著,又可以邁向下個 4 年,只要鄉民沒有放棄我們,我們就會繼續努力投注熱情在這 PPT.cc 上。

感謝一路走來始終鄉民的各位~ :)

順便整理一下最近完成與未完的事:

  • 修正 ( ) 符號出現在短網址造成轉貼不便的問題
  • 改善尖峰時段極度緩慢不穩定的問題
  • 增加備援容錯機制 (未完)
  • 修復有圖功能 (未完)
  • PPT.cc 一路走來艱辛,多謝鄉民貴人相助

    放廣告 這件事情,我們比任何人都還掙扎!

    草創時期的PPT.cc,沒有人脈、沒有資源,當時站長自掏腰包在"智邦"租了空間,開始服務~ 可惜好景不常,智邦以占用主機資源過多頻頻停權,後來求助XDITE 長輩才獲得了智邦的奧援,暫時有了穩定的家~ 無奈最後也是因為頻寬耗用過多(88風災PPT.cc成了許多救災訊息的轉貼工具,因而被智邦掃地出門)

    後來~ 站長與技術長兩個自掏腰包、買設備、分攤頻寬,讓PPT.cc有了一個穩定的窩,最早是服務在 VDSL 架設的雙向10M 光世代,一個月燒掉我們兩個人一半的薪水,但甘之如飴,很多人希望入主PPT.cc,但是我們害怕像城邦入主痞X邦、YAHOO入主無X小站那樣,喪失自主權,上頭有個大老闆永遠主導了這個站的未來… 直到遇到了目前的金主,願意出資但不介入經營~ 讓PPT.cc保有了自己的個性

    我們很珍惜也很戰戰兢兢,但錢…總有燒完的一天,我們沒有跟鄉民要求過任何捐款,因為這會讓事情變得複雜,營利不是我們所要的,我們只希望繼續營運、繼續開發符合鄉民期待的服務給大家使用~

    不得已我們在佔用頻寬最大的文章、圖片區的下半區,初步測試放入了廣告,看是否能讓這一點點不影響到使用者閱讀的情況下,做一點點頻寬費用的補貼。

    目前提供圖片的中華電信雙向20M 企業光纖,一個月就燒掉我們將近兩萬元,另外還有電費、房租等,而我們的關鍵字廣告,目前收入則是不穩定的3000~5000元,仍入不敷出,懇請鄉民們能體諒~

    若有任何的建議與意見,我們都會很樂意聽到~ 請告訴我們~ 謝謝您

    一路走來始終鄉民的 PPT.cc
    PPT 損益表

    新五都地址修正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, '高雄縣','高雄市');

    [徵人啟事]我們公司要找四個程式設計師、兩個 MIS

    程式設計師需要熟 php(4) 、MySQL(5) 大概就這樣

    MIS 除了基本的軟硬體故障排除之外,熟悉 FreeBSD 尤佳
    有興趣的可以帶作品/技能面試。

    上班的地點在林口的偏遠山區,交通不便,開始工作後,
    會需要隨著專案派往大陸,要先有心理準備唷

    想試試看的,發個信到 admix@ppt.cc 吧~ 感謝

    [尋找主人] 林口哈士奇走失了,請幫他回家

    近日來我們公司門口來一個位貴客,是特殊色的哈士奇

    她是女生唷! 大概三天前來的 (3/17) 左後腳的指甲有裂傷,包紮後無大礙

    性格溫馴,聽得懂坐下、也會跟人握手

    不會怕生,很喜歡人家帶著他跑,很活潑~ 大概 3 歲 (獸醫師說的) 體重 18 公斤

    若您有遺失愛犬,請電 02-26041090 / 0928-389698 找孫先生 謝謝

    附上圖片:

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc縮圖服務

    PPT.cc 需要企業伸出援手! 徵求頻寬與主機!

    PPT.cc 從去年四月多創站以來,秉持著鄉民心~鄉土情~
    努力開發各個有趣的服務來提供大家使用。

    近來八八水災憾事,全國人民同哀,在大家伸出援手救援之際,救災資訊也因應而生
    PPT.cc 也隨著各位網友熱情使用,在上面轉貼、分享資訊,因而造成頻寬超量,
    一直免費贊助我們主機、頻寬的智邦生活館,因此對我們提出搬家的要求。

    秉持著能替大家保留證據,提供最快速、最便利的小工具的 PPT.cc
    希望企業能夠提供小站一個新的棲身之所,我們要求的不多,但是不希望造成貴單位任何困擾,
    我們管理團隊會依舊維持中立、謹慎、管理的方向,來提供所有網友最大空間的創作與應用。

    在此徵求能夠提供大頻寬的連線單位,與我們洽談,敝小站風災搜救時的巔峰流量曾到達100Mbps
    平常時段的流量約為 4Mbps 左右,因為這次突如其來的 Peak,讓智邦做出把我們請走的決定,
    雖然錯愕,但也是很無奈的。主機部份,FreeBSD/Linux 均可,支援 PHP、MySQL 資料庫。

    在此懇請各界幫忙,畢竟目前團隊也都是自己出錢在燒頻寬做公益,我們都自掏腰包,每個月負擔
    中華雙向 10M 的光纖外(用於快照/月繳12600),其他費用就全靠智邦的贊助了,若是少了贊助,
    將會嚴重影響到本站的服務。

    謝謝各位 (並在此婉謝所有金錢贊助,PPT.cc 公益團隊敬上)

    原來中華電信企業FTTB 下午六點就沒人值班….

    網站快照使用的是中華電信雙向10M 的 FTTB,

    理應是企業級服務的水準,原來這個企業FTTB (應該稱之為 專業型FTTB 32個IP的)

    是一樣六點下班之後就沒人處理的孤兒,從七點 CALL 工程師 CALL 到現在還不知去向

    請各位企業主要申請 FTTB 之前先三思,是否真的要花錢卻得不到服務

    尤其是需要24小時連網的網站主,更要注意,這路收超貴的 FTTB~

    也是會跟著經濟型的 FTTB 一起下班,報修….. ? 等明天吧

    PPT.cc 全面支援 Plurk 貼文、貼圖

    本來是在觀察短網址網站的興衰,基本上 0rz.twis.gd 這兩家,可以算是打得火熱,’

    互相交叉在吃流量,誰高誰低,似乎還沒有分曉,只是在黃金交叉之後,is.gd 似乎更勝一籌

    PPT.cc縮圖服務

    只是,螳螂捕蟬,黃雀在後, Bit.ly 這個短網址網站,才真的是讓
    同是身為提供短網址服務的我們汗顏….

    PPT.cc縮圖服務

    在去年十一月悄悄的黃金交叉之後,bit.ly 整個完全沒有介入過 is.gd0rz.tw 的拉鋸,直接就一飛衝天…
    尤其是它提供了 Twitter 的發文功能,真的讓許多長輩級的 Twitter 重度使用者愛上 bit.ly
    PPT.cc縮圖服務

    從這邊也啟發了 PPT.cc,剛好最近也爆發了 PlurkPix 居然因為沒錢就收掉的囧境,
    於是 PPT.cc 就著手開發了 Plurk 相關的服務,也不算開發啦,只是多加上一些便利的功能,
    包括縮網址、縮文章,都可以從 PPT.cc 發送過去,也可以把圖貼過去唷~

    PPT.cc縮圖服務

    有興趣的可以看這篇教學唷: http://ppt.cc/t/Plurk.html

    最後…雖然看起來短網址界,廝殺得很厲害,可惜大者恆大,處在雲端的 TinyURL
    不知道何時才能撼動到他的地位。
    PPT.cc縮圖服務

    抓圖好幫手 – IE Screenshot + 縮圖剪剪樂

    有時候看到網站上的資訊想要分享,有時候又要裝抓圖軟體,然後又在自己剪裁、轉檔

    真的是浪費許多時間,因此 PPT.cc 找出了一個比較快速的方法,來完成這個工作~

    先在這邊推薦一套不錯的軟體,甚至是家裡的長輩都能輕鬆上手的抓圖軟體:

    IE Screenshot (http://www.iescreenshot.com/)
    IE Screenshot™ Free – Save Web Page as BMP

    偷偷說一下,這套免費版比付費版還好用,因為她主要功能就是一顆按鈕,按下去就把畫面全抓完,然後存成BMP格式。

    唯一個缺點是BMP檔案太大,所以透過一般的上傳會相當浪費頻寬,而且緩慢,在這邊我們特別設計了拖曳上傳,他還支援檔案壓縮,在測試的時候我們是使用「3G手機上網」,上傳依然不會太慢,就可以將檔案拉到「縮圖剪剪樂」裡面進行剪裁,詳細的步驟就不做太多的說明了,有興趣的可以看以下的影片(有點模糊就是了Orz)

    首頁 > 未分類

    搜索
    信息聚合
    其它

    Return to page top