/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 vote112 views1 answer
Sql server select top 2 of each group
SQL
0 vote140 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote115 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote111 views2 answers
Sql auto update dupdated_at
SQL
0 vote110 views1 answer
Sql server update top n records
SQL
0 vote71 views1 answer
Update set with join pl sql
SQL
1 vote73 views2 answers
Get date from datetime postgresql
SQL
0 vote116 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote117 views1 answer
Sql padd let with zeros
SQL
2 votes111 views5 answers
Tablespace ORACLE
SQL