mysql/core_cities_merge.sql
authorEdward <edward@roojs.com>
Fri, 27 Jun 2014 07:11:08 +0000 (15:11 +0800)
committerEdward <edward@roojs.com>
Fri, 27 Jun 2014 07:11:08 +0000 (15:11 +0800)
mysql/core_cities_merge.sql

index 949af7a..d4426c3 100644 (file)
@@ -116,9 +116,9 @@ CREATE FUNCTION core_cities_merge_division()  RETURNS INT DETERMINISTIC
                 
             END IF;
 
-            SELECT id INTO v_division_id FROM core_geoip_division WHERE (name = v_local_name OR (name LIKE (CONCAT('%', v_local_name, '%')) AND code = SUBSTRING_INDEX(v_iso, '-', -1)) AND country_id = v_country_id;
+            SELECT id INTO v_division_id FROM core_geoip_division ;
 
-            IF(v_division_id = 0) THEN
+            IF v_division_id = 0 THEN
                 
                 INSERT INTO core_geoip_division (code, name, country_id) VALUES (v_iso, v_local_name, v_country_id);
             END IF;