SELECT
*,
ROUND(
6378138 * 2 * ASIN(
SQRT(
POW(
SIN(
(
40.0497810000 * PI() / 180 - latitude * PI() / 180
) / 2
),
2
) + COS(40.0497810000 * PI() / 180) * COS(latitude * PI() / 180) * POW(
SIN(
(
116.3424590000 * PI() / 180 - longitude * PI() / 180
) / 2
),
2
)
)
)
) AS juli
FROM
table
WHERE
tiaojian <> 0
ORDER BY
juli ASC
LIMIT 0 , 1
当前语句如上,但是还想将juli也当where条件,不知道该如何写才好,新手求指教~谢谢
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…