/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 vote266 views1 answer
Mysql multiple group by
SQL
0 vote184 views1 answer
Select password from user mysql
SQL
1 vote241 views1 answer
Sql server locks
SQL
5 votes210 views1 answer
Oracle nls instance
SQL
0 vote202 views1 answer
Migration graphql
SQL
0 vote193 views1 answer
Create mysql pool connection python flask
SQL
-1 vote178 views3 answers
Check table exist postgresql
SQL
-1 vote199 views1 answer
Module operator in oracle sql
SQL
-1 vote181 views1 answer
How to switch user in mysql
SQL
9 votes230 views4 answers
Oracle get table column names
SQL