Given a latitude/longitude, we want to find all records from geoaddress table that are within a certain radius from a given latitude/longitude.

Here is java code snippet for that:

//Update lat, lon, radius variables with whatever values you want! The lat/lon together form the point from where search is performed.
double lat=20;
double lon=55;
double radius=1; //Note: 1 unit (or degree) is equivalent to 69 miles. So for a 100 mile search, this should be set to 1.45