/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 vote184 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
2 votes211 views1 answer
Oracle block
SQL
0 vote185 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote178 views1 answer
Mysql regex exact match
SQL
0 vote188 views1 answer
How to create an SQL save method in ruby
SQL
1 vote195 views1 answer
Postgres first_value in gropby
SQL
1 vote197 views1 answer
Psql search table
SQL
92 votes326 views6 answers
Substring
SQL
1 vote193 views1 answer
Mysql pretty date format
SQL
3 votes182 views1 answer
Oracle wait
SQL