/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 vote402 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote321 views1 answer
Multiple tricky query in sql server
SQL
3 votes327 views1 answer
Force using index plsql
SQL
0 vote353 views1 answer
Neo4j command to run script file
SQL
0 vote337 views1 answer
Sql server pivot rows to columns
SQL
2 votes308 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote348 views1 answer
Convert LDAP Epoch to Date
SQL
3 votes398 views2 answers
Oracle drop sequence
SQL
1 vote369 views1 answer
Mysql update inner
SQL
0 vote291 views1 answer
Sqlite3 now
SQL