/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 vote145 views2 answers
How to drop mili second in sql
SQL
11 votes145 views4 answers
Update row in mysql
SQL
0 vote124 views2 answers
Get top 1 row of each group
SQL
-1 vote135 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote205 views1 answer
Connect google bigquery connect using sqirrel
SQL
7 votes129 views6 answers
Reset identity column in sql server
SQL
0 vote129 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote279 views2 answers
Create fulltext index mysql
SQL
16 votes156 views1 answer
Sql comment'
SQL
3 votes166 views1 answer
How to add unique constraint in mysql table
SQL