mysql根据经纬度计算距离并排序

    SELECT
*,
ROUND(
    6378.138 * 2 * ASIN(
        SQRT(
            POW(
                SIN((
                        37.921289 * PI()/ 180-latitude * PI()/ 180 
                        )/ 2 
                ),
                2 
                )+ COS( 37.921289 * PI()/ 180 )* COS( latitude * PI()/ 180 )* POW(
                SIN((
                        112.648139 * PI()/ 180-longitude * PI()/ 180 
                        )/ 2 
                ),
                2 
            )))* 1000 
) AS distance 
FROM t_store ORDER BY distance ASC