sql query to find nearby location

Firstly, you need to add function in mysql i.e.

phpmyadmin > your database > table from which you want to get data

click here to get sql function

 

Then execute select query:

here distance < 50 is less than 50 miles.

 

Share This:

Leave a Reply

Your email address will not be published. Required fields are marked *