/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 vote366 views1 answer
Apex for oracle 11g
SQL
0 vote340 views2 answers
Null value in column violates not-null constraint
SQL
2 votes331 views2 answers
Exec procedure pl sql
SQL
0 vote353 views1 answer
Plpgsql raise notice
SQL
0 vote341 views1 answer
Postgresql delete multiple rows
SQL
4 votes371 views1 answer
Oracle nls_date_format
SQL
2 votes350 views1 answer
Postgresql create schema in specific database
SQL
24 votes339 views2 answers
Alter table delete column
SQL
0 vote433 views1 answer
Plpgsql create function
SQL
15 votes374 views3 answers
Postgresql change column type
SQL