MySQL 距离函数st_distance()使用示例

@Select("SELECT FORMAT(start_lat, 6) lat, FORMAT(start_lng, 6) lng,  COUNT(0) num \n" +
            "  FROM heat_map \n" +
            "  WHERE go_date > #{startDate} \n " +
            "    AND order_type = " + OrderTypeEnum.INSIDE + " " +
            "    AND st_distance (POINT(FORMAT(start_lng, 6), FORMAT(start_lat, 6)), POINT(#{lng}, #{lat}))*(6371000*PI()/180) < 20000 \n" +
            "    GROUP BY FORMAT(start_lat, 6), FORMAT(start_lng, 6) ")
    List<Map> getHeatMap(Date startDate, String lat, String lng);