Find nearest points with MySQL from points Table
<p>I have a <a href="https://en.wikipedia.org/wiki/Table_(database)" rel="noreferrer">DB Schema</a> like this (from <a href="https://developers.google.com/maps/articles/phpsqlsearch_v3?csw=1#creating-the-table" rel="noreferrer"><strong>this tutorial by Google</strong></a>) -</p>

<p><a href="https://i.stack.imgur.com/OD3Ur.png" rel="noreferrer"><img src="https://i.stack.imgur.com/OD3Ur.png" alt="DB Schema"></a></p>

<p>So the actual points in a graph for them is like this-</p>

<p><a href="https://i.stack.imgur.com/2AGja.png" rel="noreferrer"><img src="https://i.stack.imgur.com/2AGja.png" alt="Physical Location"></a></p>

<p>What I want is to find points near a given point (by <strong>point_id</strong>) point ordered by distance</p>

<blockquote>
  <p>Location of a point <code>(x,y)</code> is (<code>point_x</code>,<code>point_y</code>) in DB</p>
</blockquote>

<p>I want to solve it with <a href="https://www.mysql.com/" rel="noreferrer">MySQL</a> because my DB is already in MySQL.</p>

<hr>

<h2>Update-</h2>

<p>Finding distance of 2 points is so easy like this-</p>

<p><a href="https://i.stack.imgur.com/d1HOi.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/d1HOi.jpg" alt="Finding distance"></a></p>

<p>I want to sort on distance with MySQL.</p>

<hr>

<h2>Re-</h2>

<p>For removing the confusions, I want the points inside the circle, later. But now I want to find only the sorted points.</p>

<p>So u can ignore the circles.</p>

<hr>

<p>I don't have any idea how to do it, can anyone please help?</p>