I have two tables that contain spatial geo data. For example I have one table pois that has columns latitude and longitude and a second table cities that also has two columns latitude and longitude.
What I want to create a list of all cities in relation to all pois where the distance is not more than 100km.
Is that possible via mysql? Lets say we have about 500k cities and 1k POIs. I didn't find a way to do that in one live query but maybe you have a solution for that. Would be amazing!!
Thanks a lot.