/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

18 votes266 views4 answers
Uninstall mysql on ubuntu
SQL
13 votes271 views3 answers
Sql select from multiple tables without join
SQL
0 vote283 views1 answer
Compare field sql server
SQL
2 votes289 views2 answers
Postgres timestamp to datetime
SQL
0 vote254 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
6 votes281 views2 answers
Oracle trigger
SQL
0 vote258 views1 answer
Sql auto_increment syntax
SQL
0 vote257 views2 answers
Php convert dbf to mysql
SQL
1 vote271 views1 answer
Mysql return if it contains
SQL
0 vote268 views1 answer
Nosql vs sql
SQL