/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 vote209 views1 answer
TSQL Find csv file in folder
SQL
0 vote148 views1 answer
Mysql 8 geo to json
SQL
1 vote153 views1 answer
Show indices in mysql table
SQL
0 vote166 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote148 views1 answer
Will graphql replace sql
SQL
1 vote274 views2 answers
Postgres select from last 3 months
SQL
0 vote153 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote143 views1 answer
Postgres read table structure
SQL
0 vote149 views1 answer
Sql alternative to max statement
SQL
0 vote154 views1 answer
How to connect to mysql in ef 6
SQL