title: An SQL query to fetch all the cities that are, as the bird flies, within a distance from a given coordinate?
body: <p>I'm currently using this query to get a town inside my DB by giving a coordinate :<br></p>
  
  <pre><code>SELECT *
  FROM citiesTable
  WHERE latitude  &gt;= ? AND latitude  &lt;= ?
    AND longitude &gt;= ? AND longitude &lt;= ?;
  </code></pre>
  
  <p>This code works well and do I want but sometimes the query doesn't match anything... 
  So, in this case, I would put a bird distance to this query in order to get adjacent town.<br>
  Any suggestion on how can I do that ?</p>