title: Distance in Kilometer using MySql in PHPmyadmin
body: <p>I am using PHPmyadmin for mysql.</p>
  
  <p>I want to find the distance between 2 latitude and longitude from a table.</p>
  
  <p>I am using the following query to find the distance.</p>
  
  <p>But it returns in miles . How can get the distance in kilometer</p>
  
  <pre><code>Select @dist:=((ACOS(SIN(1.3903496 * PI() / 180) * SIN(latitude * PI() / 180) + COS(1.3903496 * PI() / 180) * COS(latitude * PI() / 180) * COS((103.8846613- longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance from tabl_name
  </code></pre>