/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

4 votes196 views1 answer
Update table from another table oracle
SQL
6 votes207 views2 answers
Oracle undotbs usage
SQL
0 vote191 views1 answer
Postgresql comandos basicos
SQL
25 votes232 views3 answers
Mysql command show tables
SQL
1 vote241 views1 answer
Sql select sum group by id laravel
SQL
-1 vote196 views1 answer
What is in operator
SQL
0 vote189 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote180 views1 answer
Call scalar valued function sql
SQL
1 vote204 views1 answer
Sql find column name like
SQL
0 vote194 views1 answer
Oracle select partition
SQL