title: Fetch Country/City wise data from MySql table using Latitude and Longitude colomns
body: <p>Here is my sample table</p>
  
  <pre><code>table name: activitylog
  
  id |    activity  |  lat        |   long
  ---+--------------+-------------+-------------
   1 |  activity1   | 11.2742848  |  75.8013801
   2 |  activity2   | 11.2742848  |  75.8013801
   3 |  activity3   | 11.2742848  |  75.8013801
   4 |  activity4   | 11.2742848  |  75.8013801
  </code></pre>
  
  <p>I have to select entries which belong to specific countries/cities from above. There is no separate column for country or city. I am bothered about  google's <strong>Geolocation API</strong>. But for a long table, checking each entry whether belong it my area is very slow process  </p>
  
  <p>Do I need store all the Lat and Long details in another table? which is best practice?</p>
  
  <p><strong>Edit:</strong> In my case, storing city or country info above table is not possible.</p>