/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 vote268 views1 answer
How to get number of months between 2 dates sql server
SQL
5 votes234 views2 answers
Functions
SQL
0 vote195 views1 answer
Get all employees if name ends with in sql
SQL
1 vote212 views2 answers
Begin transaction sql
SQL
0 vote192 views1 answer
Sql server manager close connection
SQL
0 vote203 views1 answer
Oracle simple quote
SQL
0 vote221 views1 answer
Sql sort ages
SQL
1 vote206 views2 answers
Foreign key set 0
SQL
0 vote281 views1 answer
Install ms sql server management studio
SQL
0 vote198 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL