/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

5 votes342 views1 answer
Sql integer to serial
SQL
40 votes359 views6 answers
Update table mysql
SQL
1 vote316 views1 answer
Postgresql blocked on mac
SQL
1 vote301 views1 answer
Set mysql mode global query
SQL
0 vote277 views1 answer
FindAllBy
SQL
1 vote276 views1 answer
Oracle boolean to varchar
SQL
3 votes366 views1 answer
Oracle undo tablespace schema
SQL
0 vote321 views1 answer
Mysql readable output
SQL
2 votes355 views1 answer
Show max_allowed_packet mysql
SQL
18 votes310 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL