SELECT id,name,photo,intro,address,FORMAT(calculateLineDistance(latitudeY,latitudeX,108.686650,34.274780)/1000,2) AS juli
FROM lm_shop WHERE status=0 ORDER BY juli
...全文
571打赏收藏
MySQL这样使用order Buy没用,求解决
SELECT id,name,photo,intro,address,FORMAT(calculateLineDistance(latitudeY,latitudeX,108.686650,34.274780)/1000,2) AS juli FROM lm_shop WHERE status=0 ORDER BY juli