/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

1 vote148 views1 answer
Delete mysql from mac
SQL
1 vote149 views1 answer
T-SQL Alter the column data type
SQL
0 vote150 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote174 views1 answer
Into operator in sql
SQL
0 vote143 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote148 views1 answer
Split string by comma in sql server
SQL
8 votes146 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote143 views1 answer
Max length found in mysql
SQL
0 vote149 views1 answer
What is logical database schema
SQL
0 vote160 views1 answer
Mysql change innodb to myisam
SQL