Haversign Formula

SELECT
    ROUND( 3956 * 2 *
    ASIN (
        SQRT (
            POWER(SIN( ( {SEARCH LATITUDE} - {LOCATION LATITUDE} ) * pi() / 180 / 2), 2)
            + COS(  {SEARCH LATITUDE} * pi() / 180 )
            * COS( {LOCATION LATITUDE} * pi() / 180 )
            * POWER( SIN( ( {SEARCH LONGITUDE} - {LOCATION LONGITUDE} ) * pi() / 180 / 2), 2)
            )
        ), 2
    ) as 'distance'
FROM
    table
HAVING distance < :distance