/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

3 votes254 views1 answer
V$session not found in oracle
SQL
0 vote298 views1 answer
.sql File Run in PSQL
SQL
0 vote263 views1 answer
Mysql installer no packages found
SQL
4 votes277 views2 answers
Mysql delete user if exists
SQL
0 vote253 views1 answer
Mysql select row with min date
SQL
0 vote272 views1 answer
Mysql sql select one day before
SQL
1 vote275 views1 answer
Alphabetical order mysql
SQL
1 vote253 views1 answer
Oracle lowercase
SQL
0 vote282 views1 answer
How much space does sql server take per row
SQL
0 vote287 views1 answer
Create a sql server database programmatically
SQL