chinese-addr.sql

-- You know how accurate it is
SELECT *
  FROM ADDRESS_TABLE
 WHERE (   ADDRESS LIKE '%北京%'
        OR ADDRESS LIKE '%湖南%'
        OR ADDRESS LIKE '%長沙%'
        OR ADDRESS LIKE '%天津%'
        OR ADDRESS LIKE '%廣東%'
        OR ADDRESS LIKE '%廣州%'
        OR ADDRESS LIKE '%河北%'
        OR ADDRESS LIKE '%石家莊%'
        OR ADDRESS LIKE '%廣西%'
        OR ADDRESS LIKE '%南寧%'
        OR ADDRESS LIKE '%山西%'
        OR ADDRESS LIKE '%太原%'
        OR ADDRESS LIKE '%海南%'
        OR ADDRESS LIKE '%海口%'
        OR ADDRESS LIKE '%內蒙古%'
        OR ADDRESS LIKE '%呼和浩特%'
        OR ADDRESS LIKE '%重慶%'
        OR ADDRESS LIKE '%遼寧%'
        OR ADDRESS LIKE '%沈陽%'
        OR ADDRESS LIKE '%四川%'
        OR ADDRESS LIKE '%成都%'
        OR ADDRESS LIKE '%吉林%'
        OR ADDRESS LIKE '%長春%'
        OR ADDRESS LIKE '%貴州%'
        OR ADDRESS LIKE '%貴陽%'
        OR ADDRESS LIKE '%黑龍江%'
        OR ADDRESS LIKE '%哈爾濱%'
        OR ADDRESS LIKE '%雲南%'
        OR ADDRESS LIKE '%昆明%'
        OR ADDRESS LIKE '%上海%'
        OR ADDRESS LIKE '%西藏%'
        OR ADDRESS LIKE '%拉薩%'
        OR ADDRESS LIKE '%江蘇%'
        OR ADDRESS LIKE '%南京%'
        OR ADDRESS LIKE '%陝西%'
        OR ADDRESS LIKE '%西安%'
        OR ADDRESS LIKE '%浙江%'
        OR ADDRESS LIKE '%杭州%'
        OR ADDRESS LIKE '%甘肅%'
        OR ADDRESS LIKE '%蘭州%'
        OR ADDRESS LIKE '%安徽%'
        OR ADDRESS LIKE '%合肥%'
        OR ADDRESS LIKE '%青海%'
        OR ADDRESS LIKE '%西寧%'
        OR ADDRESS LIKE '%福建%'
        OR ADDRESS LIKE '%福州%'
        OR ADDRESS LIKE '%寧夏%'
        OR ADDRESS LIKE '%銀川%'
        OR ADDRESS LIKE '%江西%'
        OR ADDRESS LIKE '%南昌%'
        OR ADDRESS LIKE '%新疆%'
        OR ADDRESS LIKE '%烏魯木齊%'
        OR ADDRESS LIKE '%山東%'
        OR ADDRESS LIKE '%濟南%'
        OR ADDRESS LIKE '%河南%'
        OR ADDRESS LIKE '%鄭州%'
        OR ADDRESS LIKE '%湖北%'
        OR ADDRESS LIKE '%武漢%')
       AND ADDRESS NOT LIKE '%香港%'
       AND ADDRESS NOT LIKE '%新界%'
       AND ADDRESS NOT LIKE '%九龍%'
       AND ADDRESS NOT LIKE '%澳門%'
       AND ADDRESS NOT LIKE '%台灣%'
       AND ADDRESS NOT LIKE '%台北%'