56,687
社区成员
发帖
与我相关
我的任务
分享
select `id`,'title','distant' from idlife_shop as a inner join (select `id`,idlifegeo( 114.0869411, `coordinateX` , 22.5431184, `coordinateY` ) as `distant` from idlife_shop) as b on a.id=b.id where distant<=50 order by distant
select *
from (
SELECT `id` , `title` , idlifegeo( 114.0869411, `coordinateX` , 22.5431184, `coordinateY` ) distant`
FROM `idlife_shop`
)T
where T.distant>50
ORDER BY T.distant
select *
from (
SELECT `id` , `title` , idlifegeo( 114.0869411, `coordinateX` , 22.5431184, `coordinateY` ) distant`
FROM `idlife_shop`
)T
ORDER BY T.distant