/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 vote121 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote111 views1 answer
Oracle list proxy users
SQL
0 vote110 views1 answer
Minus equivalent in my sql
SQL
4 votes109 views4 answers
Start mysql
SQL
0 vote111 views1 answer
Sql insert tuple
SQL
0 vote134 views1 answer
Add super privilege mysql
SQL
1 vote76 views3 answers
Grant syntax in sql
SQL
2 votes106 views1 answer
Mysql create user with mysql_native_password
SQL
-2 votes116 views1 answer
Use of where in left join in mysql
SQL
0 vote124 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL