Mapping series – MySQL queries against latitude and longitude
I’m starting this series with the simplest aspect – a MySQL query to return rows based on radius from a point. This is well trodden territory, although not always explained clearly. The maths of the query is all done for you, all you need is to decide if you are using miles of kilometres, and…