/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 vote163 views1 answer
TSQL function split string
SQL
0 vote274 views1 answer
Postgresql powershell query
SQL
0 vote171 views1 answer
Oracle temporary table
SQL
0 vote171 views1 answer
Oracle sql alter view add column
SQL
0 vote171 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote178 views2 answers
Sql query in dax power bi
SQL
2 votes172 views2 answers
How to view created temporary tables in mysql
SQL
-1 vote140 views10 answers
Delete Query in SQL Server
SQL
5 votes158 views2 answers
Mysql where in array
SQL
3 votes174 views3 answers
Sql last week
SQL