Mayck Xavier mayckxavier
mayckxavier
/ distance.sql
Created
February 4, 2017 06:08
— forked from Usse/distance.sql
MySQL calculate distance between two latitude/longitude coordinates
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE FUNCTION `lat_lng_distance` (lat1 FLOAT, lng1 FLOAT, lat2 FLOAT, lng2 FLOAT) | |
| RETURNS FLOAT | |
| DETERMINISTIC | |
| BEGIN | |
| RETURN 6371 * 2 * ASIN(SQRT( | |
| POWER(SIN((lat1 - abs(lat2)) * pi()/180 / 2), | |
| 2) + COS(lat1 * pi()/180 ) * COS(abs(lat2) * | |
| pi()/180) * POWER(SIN((lng1 - lng2) * | |
| pi()/180 / 2), 2) )); | |
| END |