/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 vote356 views1 answer
MySQL - How to find word with the most similar beginning
SQL
7 votes363 views2 answers
Oracle foreign key reference table
SQL
0 vote413 views1 answer
Sql statement show all emails with dome
SQL
-1 vote372 views3 answers
Compute age mysql
SQL
0 vote349 views1 answer
Get week day name sql server
SQL
1 vote371 views1 answer
Mysql get domain from url
SQL
57 votes599 views6 answers
Mysql alter table add column
SQL
0 vote366 views1 answer
Mssql now diff 90 day
SQL
0 vote352 views1 answer
Sql select all tables from database change url
SQL
31 votes359 views4 answers
How to get duplicate records with multiple field in sql
SQL