/SQL/Distance calculator from lat long sql query

Distance calculator from lat long sql query

COALESCE(
  	( 
      6371 * acos( cos( radians({$latitude}) ) * cos( radians( `latitude` ) ) * cos( radians( `longitude` ) - radians({$longitude}) ) + sin( radians({$latitude}) ) * sin( radians( `latitude` ) ) ) 
    )
  , 0) AS distance

Similar codes

8 votes280 views1 answer
Database backup in mysql server recovery
SQL
-1 vote291 views1 answer
Module operator in oracle sql
SQL
10 votes347 views4 answers
Join multiple tables in sql
SQL
0 vote284 views1 answer
Update one column from another column in same table
SQL
0 vote292 views2 answers
Default constraint in ms sql
SQL
0 vote295 views1 answer
Update having mysql
SQL
0 vote301 views2 answers
Mysql on update current_timestamp
SQL
4 votes306 views1 answer
Postgresql list sequences
SQL
0 vote318 views1 answer
Check command
SQL
0 vote307 views1 answer
How to run mysql on terminal mac
SQL