根据网上公布的全国省市县代码我们可以发现获取省，市，县有以下规律。1：获取省份：select BH,MC from DIC_Area where BH like '__0000' order by BH 获取省份的规律为：前两位数不同后面四位是都为02.获取市：select BH,MC from dic_area where BH like SUBSTRING(BH,1,2)+'__00' and BH <> SUBSTRING(BH,1,2)+'0000' order by BH //sql 取法select BH, MC from Read More
