/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

15 votes132 views4 answers
Export mysql db using command line
SQL
0 vote130 views1 answer
Select all columns except one sql
SQL
2 votes79 views1 answer
Select sid oracle
SQL
0 vote193 views1 answer
Check user sql password from command line
SQL
0 vote144 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote135 views1 answer
Vs 2019 connect to local mysql database
SQL
5 votes125 views1 answer
Sql asynchronous stored procedure call
SQL
1 vote132 views3 answers
Sql select only time from datetime
SQL
0 vote132 views5 answers
Mode sql course
SQL
14 votes135 views2 answers
Oracle limit rows
SQL