/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 vote336 views1 answer
Mysql column start with string
SQL
4 votes368 views2 answers
REST API
SQL
9 votes424 views3 answers
Sql delete where in
SQL
0 vote378 views2 answers
Pop sql insert value into
SQL
0 vote350 views2 answers
Auto increment column in mysql query results
SQL
0 vote345 views1 answer
How to find sql server name
SQL
0 vote327 views1 answer
Update set with join pl sql
SQL
1 vote359 views1 answer
Sql alchemy with azuresql server
SQL
2 votes386 views2 answers
Spring import sql
SQL
3 votes301 views2 answers
Mysql sum with condition
SQL