/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 vote291 views2 answers
Show sql logs in spring boot
SQL
0 vote298 views2 answers
Influxdb delete measurement based on date
SQL
0 vote337 views1 answer
How to add more columns to a table in mysql
SQL
0 vote341 views1 answer
How to combine first and last nae into one columb sql
SQL
4 votes313 views1 answer
Wilayah indonesia database
SQL
0 vote368 views1 answer
How to map sql column to custom names
SQL
0 vote336 views1 answer
Psql select * from table
SQL
0 vote335 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote360 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
3 votes325 views3 answers
How to set up an auto incrementing id db browser
SQL