小黑小波比.sql语句截取字符串的子串

1.当参数值1112324312423,在表中有11代表北京1101代表东城110105代表街道.所以要根据参数查出完整的地区,比如北京市朝阳区三里屯

2.sql语句格式:

select p.* from publisher p join st on p.region = substring(st.region,1,2) ","or p.region = substring(st.region,1,4)","or p.region = substring(st.region,1,6)","or p.region = substring(st.region,1,9)","or p.region is null","or p.region = '' 

3.这样不止查询了有区域的.无区域的页查询了