/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 vote308 views1 answer
Sqlite insert or update
SQL
3 votes300 views2 answers
Oracle privileges users
SQL
0 vote300 views1 answer
Name '_mysql' is not defined
SQL
0 vote292 views1 answer
Sql query to find duplicate email address
SQL
1 vote293 views2 answers
Copy database mysql
SQL
0 vote291 views1 answer
Returning with sqlalchemy
SQL
0 vote280 views1 answer
Join in update query in mysql
SQL
0 vote275 views1 answer
Soql more than today
SQL
0 vote277 views2 answers
Mysql output csv
SQL
1 vote279 views1 answer
Sql drop with dependencies
SQL