/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

25 votes296 views3 answers
How to use a database to see tables mysql
SQL
3 votes292 views2 answers
How to delete git repo locally
SQL
1 vote286 views1 answer
Sql server kill all connections
SQL
3 votes303 views2 answers
Sqlite show table structure
SQL
0 vote262 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote271 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote299 views1 answer
Vbscript connect mssql
SQL
0 vote276 views1 answer
Difference between db.query and db.execute
SQL
7 votes257 views1 answer
Mysql unsafe update
SQL
1 vote330 views1 answer
Sql select sum group by id laravel
SQL