<div>
<div class="content wysiwyg-content">
I need a MYSQL function which receive two geo-coordinates (standard latitude and longitude expressed as DECIMAL(12,9)) and must return the distance in miles between the two points<br />
<br />
As far as i have seen these links.<br />
<br />
<a href="https://www.experts-exchange.com/questions/23080406/MySQL-5-0-spatial-data-Lat-Long-Distance-between-points-in-meters.html?sfQueryTermInfo=1+circl+distanc+great+mysql" rel="ugc">https://www.experts-exchange.com/questions/23080406/MySQL-5-0-spatial-data-Lat-Long-Distance-between-points-in-meters.html?sfQueryTermInfo=1+circl+distanc+great+mysql</a><br />
<br />
<a href="http://www.meridianworlddata.com/Distance-Calculation.asp" rel="ugc">http://www.meridianworlddata.com/Distance-Calculation.asp</a><br />
<br />
Please help me for this
</div>
</div>


I need a MYSQL function which receive two geo-coordinates (standard latitude and longitude expressed as DECIMAL(12,9)) and must return the distance in miles between the two points

As far as i have seen these links.

http://www.experts-exchange.com/Database/MySQL/Q_23080406.html?sfQueryTermInfo=1+circl+distanc+great+mysql

http://www.meridianworlddata.com/Distance-Calculation.asp

Please help me for this

Great Circle Distance

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.