距离计算

SELECT id,storename,storecode,storetype, area, tel, lon,lat, fuwu1,fuwu2,fuwu3,fuwu4,fuwu5,fuwu6,fuwu7,fuwu8,fuwu9,fuwu10,fuwu11,fuwu12,isyibao,yibaotype,haszhongyao,storeimg,hasdoctor ,concat(province ,city ,district,street)as storeaddress FROM hx_store where lat<>0 and lat>25.03550339197 and lat<25.04449660803 and lon>102.74503692508 and lon<102.75496307492 limit 5

posted @ 2017-06-30 14:48  金于虎  阅读(157)  评论(2)  编辑  收藏  举报