2018最完整区号国家手机号正则

整理了最全最完整的国家区号+手机号验证的正则+国家 (sql文件)

/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.6.17 : Database - wwwnetribescom
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `tc_verify` */

DROP TABLE IF EXISTS `tc_verify`;

CREATE TABLE `tc_verify` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `en` varchar(150) DEFAULT '' COMMENT '英文',
  `zh` varchar(150) DEFAULT '' COMMENT '中文',
  `code` mediumint(9) DEFAULT '0' COMMENT '区号',
  `locale` char(20) DEFAULT '' COMMENT '英文缩写',
  `preg` varchar(255) DEFAULT '' COMMENT '手机号验证规则',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=193 DEFAULT CHARSET=utf8;

/*Data for the table `tc_verify` */

insert  into `tc_verify`(`id`,`en`,`zh`,`code`,`locale`,`preg`) values (1,'Angola','安哥拉',244,'AO','/^(\\+?244)?(\\d{6})$/'),(2,'Afghanistan','阿富汗',93,'AF','/^(\\+?93)?(\\d{6})$/'),(3,'Albania','阿尔巴尼亚',355,'AL','/^(\\+?355)?(\\d{6})$/'),(4,'Algeria','阿尔及利亚',213,'DZ','/^(\\+?213|0)(5|6|7)\\d{8}$/'),(5,'Andorra','安道尔共和国',376,'AD','/^(\\+?376)?(\\d{6})$/'),(6,'Anguilla','安圭拉岛',1264,'AI','/^(\\+?1264)?(\\d{6})$/'),(7,'Antigua and Barbuda','安提瓜和巴布达',1268,'AG','/^(\\+?1268)?(\\d{6})$/'),(8,'Argentina','阿根廷',54,'AR','/^(\\+?54)?(\\d{6})$/'),(9,'Armenia','亚美尼亚',374,'AM','/^(\\+?374)?(\\d{6})$/'),(10,'Ascension','阿森松',247,'','/^(\\+?247)?(\\d{6})$/'),(11,'Australia','澳大利亚',61,'AU','/^(\\+?61|0)4\\d{8}$/'),(12,'Austria','奥地利',43,'AT','/^(\\+?43)?(\\d{6})$/'),(13,'Azerbaijan','阿塞拜疆',994,'AZ','/^(\\+?994)?(\\d{6})$/'),(14,'Bahamas','巴哈马',1242,'BS','/^(\\+?1242)?(\\d{6})$/'),(15,'Bahrain','巴林',973,'BH','/^(\\+?973)?(\\d{6})$/'),(16,'Bangladesh','孟加拉国',880,'BD','/^(\\+?880)?(\\d{6})$/'),(17,'Barbados','巴巴多斯',1246,'BB','/^(\\+?1246)?(\\d{6})$/'),(18,'Belarus','白俄罗斯',375,'BY','/^(\\+?375)?(\\d{6})$/'),(19,'Belgium','比利时',32,'BE','/^(\\+?32|0)4?\\d{8}$/'),(20,'Belize','伯利兹',501,'BZ','/^(\\+?501)?(\\d{6})$/'),(21,'Benin','贝宁',229,'BJ','/^(\\+?229)?(\\d{6})$/'),(22,'Bermuda Is.','百慕大群岛',1441,'BM','/^(\\+?1441)?(\\d{6})$/'),(23,'Bolivia','玻利维亚',591,'BO','/^(\\+?591)?(\\d{6})$/'),(24,'Botswana','博茨瓦纳',267,'BW','/^(\\+?267)?(\\d{6})$/'),(25,'Brazil','巴西',55,'BR','/^(\\+?55|0)\\-?[1-9]{2}\\-?[2-9]{1}\\d{3,4}\\-?\\d{4}$/'),(26,'Brunei','文莱',673,'BN','/^(\\+?673)?(\\d{6})$/'),(27,'Bulgaria','保加利亚',359,'BG','/^(\\+?359)?(\\d{6})$/'),(28,'Burkina-faso','布基纳法索',226,'BF','/^(\\+?226)?(\\d{6})$/'),(29,'Burma','缅甸',95,'MM','/^(\\+?95)?(\\d{6})$/'),(30,'Burundi','布隆迪',257,'BI','/^(\\+?257)?(\\d{6})$/'),(31,'Cameroon','喀麦隆',237,'CM','/^(\\+?237)?(\\d{6})$/'),(32,'Canada','加拿大',1,'CA','/^(\\+?1)?(\\d{6})$/'),(33,'Cayman Is.','开曼群岛',1345,'','/^(\\+?1345)?(\\d{6})$/'),(34,'Central African Republic','中非共和国',236,'CF','/^(\\+?236)?(\\d{6})$/'),(35,'Chad','乍得',235,'TD','/^(\\+?235)?(\\d{6})$/'),(36,'Chile','智利',56,'CL','/^(\\+?56)?(\\d{6})$/'),(37,'China','中国',86,'CN','/^(\\+?0?86\\-?)?1[345789]\\d{9}$/'),(38,'Colombia','哥伦比亚',57,'CO','/^(\\+?57)?(\\d{6})$/'),(39,'Congo','刚果',242,'CG','/^(\\+?242)?(\\d{6})$/'),(40,'Cook Is.','库克群岛',682,'CK','/^(\\+?682)?(\\d{6})$/'),(41,'Costa Rica','哥斯达黎加',506,'CR','/^(\\+?506)?(\\d{6})$/'),(42,'Cuba','古巴',53,'CU','/^(\\+?53)?(\\d{6})$/'),(43,'Cyprus','塞浦路斯',357,'CY','/^(\\+?357)?(\\d{6})$/'),(44,'Czech Republic','捷克',420,'CZ','/^(\\+?420)? ?[1-9][0-9]{2} ?[0-9]{3} ?[0-9]{3}$/'),(45,'Denmark','丹麦',45,'DK','/^(\\+?45)?(\\d{8})$/'),(46,'Djibouti','吉布提',253,'DJ','/^(\\+?253)?(\\d{6})$/'),(47,'Dominica Rep.','多米尼加共和国',1890,'DO','/^(\\+?1890)?(\\d{6})$/'),(48,'Ecuador','厄瓜多尔',593,'EC','/^(\\+?593)?(\\d{6})$/'),(49,'Egypt','埃及',20,'EG','/^(\\+?20)?(\\d{6})$/'),(50,'EI Salvador','萨尔瓦多',503,'SV','/^(\\+?503)?(\\d{6})$/'),(51,'Estonia','爱沙尼亚',372,'EE','/^(\\+?372)?(\\d{6})$/'),(52,'Ethiopia','埃塞俄比亚',251,'ET','/^(\\+?251)?(\\d{6})$/'),(53,'Fiji','斐济',679,'FJ','/^(\\+?679)?(\\d{6})$/'),(54,'Finland','芬兰',358,'FI','/^(\\+?358|0)\\s?(4(0|1|2|4|5)?|50)\\s?(\\d\\s?){4,8}\\d$/'),(55,'France','法国',33,'FR','/^(\\+?33|0)[67]\\d{8}$/'),(56,'French Guiana','法属圭亚那',594,'GF','/^(\\+?594)?(\\d{6})$/'),(57,'Gabon','加蓬',241,'GA','/^(\\+?241)?(\\d{6})$/'),(58,'Gambia','冈比亚',220,'GM','/^(\\+?220)?(\\d{6})$/'),(59,'Georgia','格鲁吉亚',995,'GE','/^(\\+?995)?(\\d{6})$/'),(60,'Germany','德国',49,'DE','/^(\\+?49[ \\.\\-])?([\\(]{1}[0-9]{1,6}[\\)])?([0-9 \\.\\-\\/]{3,20})((x|ext|extension)[ ]?[0-9]{1,4})?$/'),(61,'Ghana','加纳',233,'GH','/^(\\+?233)?(\\d{6})$/'),(62,'Gibraltar','直布罗陀',350,'GI','/^(\\+?350)?(\\d{6})$/'),(63,'Greece','希腊',30,'GR','/^(\\+?30)?(69\\d{8})$/'),(64,'Grenada','格林纳达',1809,'GD','/^(\\+?1809)?(\\d{6})$/'),(65,'Guam','关岛',1671,'GU','/^(\\+?1671)?(\\d{6})$/'),(66,'Guatemala','危地马拉',502,'GT','/^(\\+?502)?(\\d{6})$/'),(67,'Guinea','几内亚',224,'GN','/^(\\+?224)?(\\d{6})$/'),(68,'Guyana','圭亚那',592,'GY','/^(\\+?592)?(\\d{6})$/'),(69,'Haiti','海地',509,'HT','/^(\\+?509)?(\\d{6})$/'),(70,'Honduras','洪都拉斯',504,'HN','/^(\\+?504)?(\\d{6})$/'),(71,'Hongkong','香港',852,'HK','/^(\\+?852\\-?)?[569]\\d{3}\\-?\\d{4}$/'),(72,'Hungary','匈牙利',36,'HU','/^(\\+?36)(20|30|70)\\d{7}$/'),(73,'Iceland','冰岛',354,'IS','/^(\\+?354)?(\\d{6})$/'),(74,'India','印度',91,'IN','/^(\\+?91|0)?[789]\\d{9}$/'),(75,'Indonesia','印度尼西亚',62,'ID','/^(\\+?62)?(\\d{6})$/'),(76,'Iran','伊朗',98,'IR','/^(\\+?98)?(\\d{6})$/'),(77,'Iraq','伊拉克',964,'IQ','/^(\\+?964)?(\\d{6})$/'),(78,'Ireland','爱尔兰',353,'IE','/^(\\+?353)?(\\d{6})$/'),(79,'Israel','以色列',972,'IL','/^(\\+972|0)([23489]|5[0248]|77)[1-9]\\d{6}/'),(80,'Italy','意大利',39,'IT','/^(\\+?39)?\\s?3\\d{2} ?\\d{6,7}$/'),(81,'Ivory Coast','科特迪瓦',225,'','/^(\\+?225)?(\\d{6})$/'),(82,'Jamaica','牙买加',1876,'JM','/^(\\+?1876)?(\\d{6})$/'),(83,'Japan','日本',81,'JP','/^(\\+?81|0)\\d{1,4}[ \\-]?\\d{1,4}[ \\-]?\\d{4}$/'),(84,'Jordan','约旦',962,'JO','/^(\\+?962)?(\\d{6})$/'),(85,'Kampuchea (Cambodia )','柬埔寨',855,'KH','/^(\\+?855)?(\\d{6})$/'),(86,'Kazakstan','哈萨克斯坦',327,'KZ','/^(\\+?327)?(\\d{6})$/'),(87,'Kenya','肯尼亚',254,'KE','/^(\\+?254)?(\\d{6})$/'),(88,'Korea','韩国',82,'KR','/^(\\+?82)?(\\d{6})$/'),(89,'Kuwait','科威特',965,'KW','/^(\\+?965)?(\\d{6})$/'),(90,'Kyrgyzstan','吉尔吉斯坦',331,'KG','/^(\\+?331)?(\\d{6})$/'),(91,'Laos','老挝',856,'LA','/^(\\+?856)?(\\d{6})$/'),(92,'Latvia','拉脱维亚',371,'LV','/^(\\+?371)?(\\d{6})$/'),(93,'Lebanon','黎巴嫩',961,'LB','/^(\\+?961)?(\\d{6})$/'),(94,'Lesotho','莱索托',266,'LS','/^(\\+?266)?(\\d{6})$/'),(95,'Liberia','利比里亚',231,'LR','/^(\\+?231)?(\\d{6})$/'),(96,'Libya','利比亚',218,'LY','/^(\\+?218)?(\\d{6})$/'),(97,'Liechtenstein','列支敦士登',423,'LI','/^(\\+?423)?(\\d{6})$/'),(98,'Lithuania','立陶宛',370,'LT','/^(\\+?370)?(\\d{6})$/'),(99,'Luxembourg','卢森堡',352,'LU','/^(\\+?352)?(\\d{6})$/'),(100,'Macao','澳门',853,'MO','/^(\\+?853)?(\\d{6})$/'),(101,'Madagascar','马达加斯加',261,'MG','/^(\\+?261)?(\\d{6})$/'),(102,'Malawi','马拉维',265,'MW','/^(\\+?265)?(\\d{6})$/'),(103,'Malaysia','马来西亚',60,'MY','/^(\\+?6?01){1}(([145]{1}(\\-|\\s)?\\d{7,8})|([236789]{1}(\\s|\\-)?\\d{7}))$/'),(104,'Maldives','马尔代夫',960,'MV','/^(\\+?960)?(\\d{6})$/'),(105,'Mali','马里',223,'ML','/^(\\+?223)?(\\d{6})$/'),(106,'Malta','马耳他',356,'MT','/^(\\+?356)?(\\d{6})$/'),(107,'Mariana Is','马里亚那群岛',1670,'','/^(\\+?1670)?(\\d{6})$/'),(108,'Martinique','马提尼克',596,'','/^(\\+?596)?(\\d{6})$/'),(109,'Mauritius','毛里求斯',230,'MU','/^(\\+?230)?(\\d{6})$/'),(110,'Mexico','墨西哥',52,'MX','/^(\\+?52)?(\\d{6})$/'),(111,'Moldova, Republic of','摩尔多瓦',373,'MD','/^(\\+?373)?(\\d{6})$/'),(112,'Monaco','摩纳哥',377,'MC','/^(\\+?377)?(\\d{6})$/'),(113,'Mongolia','蒙古',976,'MN','/^(\\+?976)?(\\d{6})$/'),(114,'Montserrat Is','蒙特塞拉特岛',1664,'MS','/^(\\+?1664)?(\\d{6})$/'),(115,'Morocco','摩洛哥',212,'MA','/^(\\+?212)?(\\d{6})$/'),(116,'Mozambique','莫桑比克',258,'MZ','/^(\\+?258)?(\\d{6})$/'),(117,'Namibia','纳米比亚',264,'NA','/^(\\+?264)?(\\d{6})$/'),(118,'Nauru','瑙鲁',674,'NR','/^(\\+?674)?(\\d{6})$/'),(119,'Nepal','尼泊尔',977,'NP','/^(\\+?977)?(\\d{6})$/'),(120,'Netheriands Antilles','荷属安的列斯',599,'','/^(\\+?599)?(\\d{6})$/'),(121,'Netherlands','荷兰',31,'NL','/^(\\+?31)?(\\d{6})$/'),(122,'New Zealand','新西兰',64,'NZ','/^(\\+?64|0)2\\d{7,9}$/'),(123,'Nicaragua','尼加拉瓜',505,'NI','/^(\\+?505)?(\\d{6})$/'),(124,'Niger','尼日尔',227,'NE','/^(\\+?227)?(\\d{6})$/'),(125,'Nigeria','尼日利亚',234,'NG','/^(\\+?234)?(\\d{6})$/'),(126,'North Korea','朝鲜',850,'KP','/^(\\+?850)?(\\d{6})$/'),(127,'Norway','挪威',47,'NO','/^(\\+?47)?[49]\\d{7}$/'),(128,'Oman','阿曼',968,'OM','/^(\\+?968)?(\\d{6})$/'),(129,'Pakistan','巴基斯坦',92,'PK','/^(\\+?92)?(\\d{6})$/'),(130,'Panama','巴拿马',507,'PA','/^(\\+?507)?(\\d{6})$/'),(131,'Papua New Cuinea','巴布亚新几内亚',675,'PG','/^(\\+?675)?(\\d{6})$/'),(132,'Paraguay','巴拉圭',595,'PY','/^(\\+?595)?(\\d{6})$/'),(133,'Peru','秘鲁',51,'PE','/^(\\+?51)?(\\d{6})$/'),(134,'Philippines','菲律宾',63,'PH','/^(\\+?63)?(\\d{6})$/'),(135,'Poland','波兰',48,'PL','/^(\\+?48)? ?[5-8]\\d ?\\d{3} ?\\d{2} ?\\d{2}$/'),(136,'French Polynesia','法属玻利尼西亚',689,'PF','/^(\\+?689)?(\\d{6})$/'),(137,'Portugal','葡萄牙',351,'PT','/^(\\+?351)?9[1236]\\d{7}$/'),(138,'Puerto Rico','波多黎各',1787,'PR','/^(\\+?1787)?(\\d{6})$/'),(139,'Qatar','卡塔尔',974,'QA','/^(\\+?974)?(\\d{6})$/'),(140,'Reunion','留尼旺',262,'','/^(\\+?262)?(\\d{6})$/'),(141,'Romania','罗马尼亚',40,'RO','/^(\\+?40)?(\\d{6})$/'),(142,'Russia','俄罗斯',7,'RU','/^(\\+?7|8)?9\\d{9}$/'),(143,'Saint Lueia','圣卢西亚',1758,'LC','/^(\\+?1758)?(\\d{6})$/'),(144,'Saint Vincent','圣文森特岛',1784,'VC','/^(\\+?1784)?(\\d{6})$/'),(145,'Samoa Eastern','东萨摩亚(美)',684,'','/^(\\+?684)?(\\d{6})$/'),(146,'Samoa Western','西萨摩亚',685,'','/^(\\+?685)?(\\d{6})$/'),(147,'San Marino','圣马力诺',378,'SM','/^(\\+?378)?(\\d{6})$/'),(148,'Sao Tome and Principe','圣多美和普林西比',239,'ST','/^(\\+?239)?(\\d{6})$/'),(149,'Saudi Arabia','沙特阿拉伯',966,'SA','/^(!?(\\+?966)|0)?5\\d{8}$/'),(150,'Senegal','塞内加尔',221,'SN','/^(\\+?221)?(\\d{6})$/'),(151,'Seychelles','塞舌尔',248,'SC','/^(\\+?248)?(\\d{6})$/'),(152,'Sierra Leone','塞拉利昂',232,'SL','/^(\\+?232)?(\\d{6})$/'),(153,'Singapore','新加坡',65,'SG','/^(\\+?65)?(\\d{6})$/'),(154,'Slovakia','斯洛伐克',421,'SK','/^(\\+?421)?(\\d{6})$/'),(155,'Slovenia','斯洛文尼亚',386,'SI','/^(\\+?386)?(\\d{6})$/'),(156,'Solomon Is','所罗门群岛',677,'SB','/^(\\+?677)?(\\d{6})$/'),(157,'Somali','索马里',252,'SO','/^(\\+?252)?(\\d{6})$/'),(158,'South Africa','南非',27,'ZA','/^(\\+?27|0)\\d{9}$/'),(159,'Spain','西班牙',34,'ES','/^(\\+?34)?(6\\d{1}|7[1234])\\d{7}$/'),(160,'Sri Lanka','斯里兰卡',94,'LK','/^(\\+?94)?(\\d{6})$/'),(161,'St.Lucia','圣卢西亚',1758,'LC','/^(\\+?1758)?(\\d{6})$/'),(162,'St.Vincent','圣文森特',1784,'VC','/^(\\+?1784)?(\\d{6})$/'),(163,'Sudan','苏丹',249,'SD','/^(\\+?249)?(\\d{6})$/'),(164,'Suriname','苏里南',597,'SR','/^(\\+?597)?(\\d{6})$/'),(165,'Swaziland','斯威士兰',268,'SZ','/^(\\+?268)?(\\d{6})$/'),(166,'Sweden','瑞典',46,'SE','/^(\\+?46)?(\\d{6})$/'),(167,'Switzerland','瑞士',41,'CH','/^(\\+?41)?(\\d{6})$/'),(168,'Syria','叙利亚',963,'SY','/^(!?(\\+?963)|0)?9\\d{8}$/'),(169,'Taiwan','台湾省',886,'TW','/^(\\+?886\\-?|0)?9\\d{8}$/'),(170,'Tajikstan','塔吉克斯坦',992,'TJ','/^(\\+?992)?(\\d{6})$/'),(171,'Tanzania','坦桑尼亚',255,'TZ','/^(\\+?255)?(\\d{6})$/'),(172,'Thailand','泰国',66,'TH','/^(\\+?66)?(\\d{6})$/'),(173,'Togo','多哥',228,'TG','/^(\\+?228)?(\\d{6})$/'),(174,'Tonga','汤加',676,'TO','/^(\\+?676)?(\\d{6})$/'),(175,'Trinidad and Tobago','特立尼达和多巴哥',1809,'TT','/^(\\+?1809)?(\\d{6})$/'),(176,'Tunisia','突尼斯',216,'TN','/^(\\+?216)?(\\d{6})$/'),(177,'Turkey','土耳其',90,'TR','/^(\\+?90|0)?5\\d{9}$/'),(178,'Turkmenistan','土库曼斯坦',993,'TM','/^(\\+?993)?(\\d{6})$/'),(179,'Uganda','乌干达',256,'UG','/^(\\+?256)?(\\d{6})$/'),(180,'Ukraine','乌克兰',380,'UA','/^(\\+?380)?(\\d{6})$/'),(181,'United Arab Emirates','阿拉伯联合酋长国',971,'AE','/^(\\+?971)?(\\d{6})$/'),(182,'United Kiongdom','英国',44,'GB','/^(\\+?44|0)7\\d{9}$/'),(183,'United States of America','美国',1,'US','/^(\\+?1)?[2-9]\\d{2}[2-9](?!11)\\d{6}$/'),(184,'Uruguay','乌拉圭',598,'UY','/^(\\+?598)?(\\d{6})$/'),(185,'Uzbekistan','乌兹别克斯坦',233,'UZ','/^(\\+?233)?(\\d{6})$/'),(186,'Venezuela','委内瑞拉',58,'VE','/^(\\+?58)?(\\d{6})$/'),(187,'Vietnam','越南',84,'VN','/^(\\+?84|0)?((1(2([0-9])|6([2-9])|88|99))|(9((?!5)[0-9])))([0-9]{7})$/'),(188,'Yemen','也门',967,'YE','/^(\\+?967)?(\\d{6})$/'),(189,'Yugoslavia','南斯拉夫',381,'YU','/^(\\+?381)?(\\d{6})$/'),(190,'Zimbabwe','津巴布韦',263,'ZW','/^(\\+?263)?(\\d{6})$/'),(191,'Zaire','扎伊尔',243,'ZR','/^(\\+?243)?(\\d{6})$/'),(192,'Zambia','赞比亚',260,'ZM','/^(\\+?26)?09[567]\\d{7}$/');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;