/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 vote340 views1 answer
Mysql multiple primary keys
SQL
5 votes338 views1 answer
Minecraft java port number
SQL
-1 vote333 views1 answer
How to switch user in mysql
SQL
8 votes340 views3 answers
Alter user root mysql
SQL
0 vote330 views1 answer
Nosql vs sql
SQL
0 vote346 views1 answer
How to define a non primary composite key in sql
SQL
0 vote351 views1 answer
View t-sql mail configuration
SQL
7 votes335 views1 answer
Oracle reset sequence
SQL
0 vote320 views1 answer
TSQL function split string
SQL
11 votes361 views2 answers
How to import mysql database command line
SQL