/SQL/Php get closest location by latitude longitude

Php get closest location by latitude longitude

SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( $lat - LatOnTable) *  pi()/180 / 2), 2) +COS( $lat * pi()/180) * COS(LatOnTable * pi()/180) * POWER(SIN(( $long - LongOnTable) * pi()/180 / 2), 2) ))) as distance  
from yourTable  
having  distance <= 10 
order by distance

Source: stackoverflow.com

Similar codes

1 vote152 views1 answer
Print all records of table in mysql
SQL
0 vote142 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote138 views1 answer
Mysql user set plugin
SQL
0 vote134 views1 answer
Sql menampilkan data tabel
SQL
0 vote142 views1 answer
Sql server set complex constraints
SQL
1 vote168 views2 answers
Oracle 18c xe ORA-65096
SQL
2 votes102 views1 answer
Sql float to int
SQL
0 vote139 views1 answer
Firebase sql
SQL
0 vote137 views1 answer
Sql gap missing values
SQL
0 vote158 views2 answers
How to install mssql on mac
SQL