pedrokoblitz/distancia_coordenadas.sql

Created September 20, 2012 18:47

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pedrokoblitz/3757634.js"></script>
Save pedrokoblitz/3757634 to your computer and use it in GitHub Desktop.

Download ZIP

Calculate Distance In Mysql with Latitude and Longitude

Raw

distancia_coordenadas.sql

SELECT ((ACOS(SIN($lat * PI() / 180) * SIN(lat * PI() / 180) + COS($lat * PI() / 180) * COS(lat * PI() / 180) * COS(($lon – lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS `distance` FROM `members` HAVING `distance`<=’10′ ORDER BY `distance` ASC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment