/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

1 vote209 views1 answer
Mysql view command
SQL
1 vote222 views1 answer
Mysql copy table1 to table2
SQL
0 vote179 views0 answer
SQL
0 vote233 views1 answer
Postgres grep entire database
SQL
4 votes252 views1 answer
Postgres delete last row
SQL
9 votes202 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote218 views1 answer
Max mysql
SQL
0 vote227 views1 answer
Mysql terminal run sql file
SQL
33 votes222 views6 answers
Change column name in mysql
SQL
0 vote236 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL