/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 vote165 views1 answer
Alter column to not null with default value sql server
SQL
0 vote135 views1 answer
Initcap in sql
SQL
1 vote144 views1 answer
Show all event schedular on mysql
SQL
1 vote145 views1 answer
Find a column in all tables postgres
SQL
0 vote133 views1 answer
Update having mysql
SQL
4 votes134 views2 answers
Linq join
SQL
1 vote167 views1 answer
How to show index type in postgresql
SQL
14 votes143 views3 answers
Trim sql
SQL
1 vote140 views1 answer
Mysql how to reset primary key
SQL
2 votes140 views1 answer
Mysql add boolean column
SQL