/SQL/Radius search with point data in mysql

Radius search with point data in mysql

SELECT id, 
( 6371 * 
    ACOS( 
        COS( RADIANS( db_latitude ) ) * 
        COS( RADIANS( $user_latitude ) ) * 
        COS( RADIANS( $user_longitude ) - 
        RADIANS( db_longitude ) ) + 
        SIN( RADIANS( db_latitude ) ) * 
        SIN( RADIANS( $user_latitude) ) 
    ) 
) 
AS distance FROM the_table HAVING distance <= $the_radius ORDER BY distance ASC"

Source: stackoverflow.com

Similar codes

0 vote316 views1 answer
List all indexes postgres
SQL
0 vote293 views1 answer
Month mysql
SQL
4 votes285 views1 answer
Update table from another table oracle
SQL
4 votes312 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote284 views1 answer
What is the essence of SQL?
SQL
0 vote337 views1 answer
Date 3 months from today sql
SQL
0 vote304 views1 answer
Postgresql default value boolean
SQL
0 vote314 views1 answer
Sql pad left 0
SQL
0 vote309 views1 answer
Formatting code with SQL Developer
SQL
1 vote327 views1 answer
Key validation sql
SQL