Re: Points within km range
The solution here is the function ST_Distance_Sphere which came with the MySql release 5.7.6 this month.
SELECT * FROM image WHERE ST_Distance(GeomFromText('POINT(13.430692 52.518139)', 4326), location) <= 5000
Get all images from Point within 5km range.
Subject
Views
Written By
Posted
6092
March 11, 2015 07:57AM
2266
March 18, 2015 05:55AM
Re: Points within km range
2382
March 19, 2015 04:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.