Mysql query display records within a distance less than 100 KM
<pre><code>I have 2 tables (given sample records):
1&gt; tbl_travel
 ----------------------------------------------------------------------
 |  id     | from_loc| from_lat | from_lon |to_loc |  to_lat | to_lon |
 ----------------------------------------------------------------------
 |  TRV1   | Kolkata |34.44444  | 84.3434  | Dumka |34.44444 | 84.3434|
 ----------------------------------------------------------------------
 |  TRV2   | Vizag   |30.44222  | 83.3412  | Pune  |35.44345 | 85.3411|
 ----------------------------------------------------------------------
 |  TRV3   | Challa  |34.5672   | 82.2345  | Pune  |35.44345 | 85.3411|
 ----------------------------------------------------------------------

1&gt; tbl_agent_route
 ----------------------------------------------------------------------
 |id|agent_id|from_route|from_lat| from_lon |to_route |to_lat|to_lon|
 ----------------------------------------------------------------------
 |1 |2  | Rachi |34.44444  | 84.3434  | Durgapur|34.44444 | 84.3434|
 ----------------------------------------------------------------------
 |2 |2  | Srirampuram |30.44222  | 83.3412  | mumbai  |35.44345 | 85.3411|
 ----------------------------------------------------------------------
 |3 |1  | Dariyapur  |34.5672   | 82.2345  | Rajgir  |35.44345 | 85.3411|
 ----------------------------------------------------------------------
</code></pre>

<p>Now I need all the travel record whose from location or to location within 100 km radius of a travel agent route(from_route OR to_route) whose agent_id is 2.</p>

<p>Thanks.</p>