/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 vote192 views3 answers
How to increase size of column in sql
SQL
16 votes187 views2 answers
Sql exists
SQL
0 vote176 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote177 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote196 views1 answer
Left join vs inner join performance
SQL
6 votes195 views4 answers
Mysql get random row
SQL
2 votes189 views1 answer
Sql update from different table
SQL
0 vote236 views1 answer
Postgres rename database
SQL
0 vote192 views2 answers
Python mysql create table if not exists
SQL
1 vote184 views1 answer
Oracle sql create view
SQL