SELECT id, Longitude, Latitude, ( 3959 * acos( cos( RADIANS(50) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians(7) ) + sin( RADIANS(50) ) * sin( radians( Latitude ) ) ) ) AS distance FROM gpslocation HAVING distance < 25 ORDER BY DISTANCE LIMIT 0 , 20;Notice that number 50 is twice mentioned in query.
Finding locations that are within a certain radius distance
- Details
- Written by: Stanko Milosev
- Category: MySQL
- Hits: 1976
This example I took from here. In my case I will display markers that are in distance of 25 kilometers from Longitude = 7 and Latitude = 50.