ROUND( 6378.138 * 2 * ASIN( SQRT( POW( SIN( (#{latitude} * PI() / 180 - a.latitude * PI() / 180) / 2 ), 2 ) + COS(#{latitude} * PI() / 180) * COS(a.latitude * PI() / 180) * POW( SIN( (#{longitude} * PI() / 180 - a.longitude * PI() / 180) / 2 ), 2 ) ) ) * 1000 ) AS distance
单位:米
mybatis中 having distance <= 1000 :小于等于1000m,> = 大于等于