select s.id,s.store_name,s.lat,s.lng, (st_distance(point(s.lng,s.lat),point(108.94712,34.29318))*111195) as distance from pay_store_info as s having distance <= 20000 order by distance
转载于:https://my.oschina.net/u/3371661/blog/3099727
select s.id,s.store_name,s.lat,s.lng, (st_distance(point(s.lng,s.lat),point(108.94712,34.29318))*111195) as distance from pay_store_info as s having distance <= 20000 order by distance
转载于:https://my.oschina.net/u/3371661/blog/3099727