title: MySQL - Find points within radius from database
body: <p>I have a table which has a <code>POINT</code> column containing the latitude and longitude of various locations.</p>
  
  <p>I then also have a users location from geo-location in the browser.</p>
  
  <p>What I need to be able to do is find all records from the table where the <code>POINT</code> value in the is within a 10 km radius (or X km radius), ordered by distance with the closest first.</p>
  
  <p>My table has a <code>SPATIAL</code> index on the <code>POINT</code> column.</p>