省市区—三级联动

三级联动

select
	p.province_name,
	c.city_name,
	r.region_name,
	concat(p.province_name, c.city_name, r.region_name) names
from
	t_ba_province p
	left join t_ba_city c on p.province_code = c.province_code
	left join t_ba_region r on r.city_code = c.city_code
 where
	sp.province_name like concat('%', '北京', '%')
order by convert(p.province_name using gbk)