距离计算

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

转载于:https://www.cnblogs.com/oneboi/p/7098791.html