/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

48 votes288 views3 answers
Psql create database
SQL
14 votes263 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
2 votes247 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote260 views2 answers
Postgres default user
SQL
0 vote240 views1 answer
Update set with join pl sql
SQL
9 votes263 views4 answers
Oracle get table column names
SQL
0 vote251 views1 answer
How to create a new shema using query languaage
SQL
17 votes251 views3 answers
How to change a collumn name in sql
SQL
0 vote230 views1 answer
Import sql mysql ubuntu
SQL
14 votes267 views4 answers
Online sql compiler
SQL