Finding locations that are within a certain radius distance

Details: Written by: Stanko Milosev; Category: MySQL; Published: 12 January 2020; Last Updated: 12 January 2020; Hits: 1971

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.

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.