/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 vote205 views1 answer
Mysql utc timestamp
SQL
0 vote194 views1 answer
Concatenate columns in table
SQL
0 vote203 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
1 vote210 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
2 votes205 views2 answers
Mysql on duplicate key ignore
SQL
7 votes232 views2 answers
How to create index mysql
SQL
0 vote232 views1 answer
Mysql relationships between tables
SQL
0 vote206 views1 answer
Postgresql delete multiple rows
SQL
1 vote186 views1 answer
Mysql date diff in seconds
SQL
17 votes207 views5 answers
Order by sql
SQL