/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 vote181 views1 answer
Mysql collation for all languages
SQL
2 votes250 views2 answers
Spring where to put the data sql
SQL
0 vote230 views1 answer
Make a socket server to detect changes in mysql
SQL
1 vote253 views1 answer
Mysql connect bash
SQL
-1 vote249 views1 answer
Mysql order by on condition
SQL
2 votes242 views1 answer
Mysql last 7 days including today
SQL
0 vote213 views1 answer
Alter session set nls_language french
SQL
3 votes217 views3 answers
Mysqldump: couldn
SQL
0 vote259 views1 answer
Insert value in identity
SQL
8 votes244 views1 answer
Check mysql version phpmyadmin
SQL