mysql 经纬度坐标 距离 范围查询

查询坐标点指定范围内的其他坐标点
mybatis sql输入：lat,lon,range

SELECT
        ID id,PROJECT_NAME name,LON lon,LAT lat,TYPE icon
FROM
        ${tableName}
WHERE
        (
                6371 * acos (
                        cos ( radians(${lat}) )
                                * cos( radians(LAT) )
                                * cos( radians(LON) - radians(${lon}) )
                                + sin ( radians(${lat}) )
                                * sin( radians(LAT) )
                        )
        ) < ${range}