Skip to content

Instantly share code, notes, and snippets.

@manidip

manidip/MySQL_distance_function.sql

Forked from kimmellj/MySQL_distance_function.sql
Created March 1, 2019 11:51
Show Gist options
  • Save manidip/add22b6a7fcd6e881924b8a0cc1b2ac9 to your computer and use it in GitHub Desktop.
Save manidip/add22b6a7fcd6e881924b8a0cc1b2ac9 to your computer and use it in GitHub Desktop.
Download ZIP
This is a MySQL function that will calculate the distance between two latitude and longitude points
Raw
MySQL_distance_function.sql
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`foobar`@`localhost`*/ /*!50003 FUNCTION `distance`( lat1 DOUBLE, lon1 DOUBLE, lat2 DOUBLE, lon2 DOUBLE ) RETURNS DOUBLE
DETERMINISTIC
BEGIN
RETURN 3956 * 2 * ASIN(SQRT(POWER(SIN((lat1 - lat2) * pi()/180 / 2), 2) + COS(lat1 * pi()/180) * COS(lat2 * pi()/180) * POWER(SIN((lon1 - lon2) * pi()/180 / 2), 2)));
END */;;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment