正则表达式 取内容中间的空格

去掉'Zhong Guo' 中间的空格

(?<=[a-zA-Z+])((s))(?=[a-zA-Z]+')

INSERT INTO `region` VALUES ('1','中国','0','Zhong Guo','2');

INSERT INTO `region` VALUES ('2','110000','北京市','1','Beijing Shi','BJ');

INSERT INTO `region` VALUES ('3','120000','天津市','Tianjin Shi','TJ');

【替换结果】

INSERT INTO `region` VALUES ('1','ZhongGuo','BeijingShi','TianjinShi','TJ');