/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 vote305 views1 answer
Resullt all update knex mysql
SQL
9 votes283 views3 answers
Where in sql
SQL
15 votes299 views4 answers
Sql update from select
SQL
1 vote330 views2 answers
Intersect sql
SQL
2 votes314 views4 answers
Check timezone of mysql database
SQL
17 votes323 views4 answers
Show tables sql server
SQL
0 vote296 views1 answer
Mysql query to add hours to column in table
SQL
0 vote335 views1 answer
Delete from table where length sql
SQL
4 votes296 views2 answers
Postgre sql create table
SQL
3 votes302 views4 answers
Order by desc postgres
SQL