/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 vote143 views1 answer
Hex string sql becomes int64
SQL
0 vote144 views1 answer
Time mysql w3
SQL
0 vote137 views1 answer
Create-table-with-index-organization
SQL
4 votes161 views3 answers
Postgres drop all tables
SQL
0 vote126 views1 answer
Oracle last character of string
SQL
0 vote117 views1 answer
Count the table indatabase
SQL
4 votes168 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote138 views1 answer
Sql server concat null
SQL
0 vote125 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote118 views1 answer
Database springboot
SQL