/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

2 votes232 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote217 views1 answer
What is between operator
SQL
0 vote221 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote239 views1 answer
Postgres set default schema
SQL
1 vote229 views1 answer
Mysql show database size in mb
SQL
0 vote224 views1 answer
Sub query in linq
SQL
0 vote218 views1 answer
Insert thai language sql server
SQL
0 vote240 views1 answer
How we can perform acid Operations in sql with examples
SQL
8 votes218 views1 answer
How to remove tables from postgresql
SQL
1 vote281 views4 answers
How to check table in postgresql from terminal
SQL