title: MySQL AS in WHERE statement
body: <p>I have a MySQL database. I use a <code>SELECT AS</code> to measure "distance" between 2 points. What I want to do is use the same "distance" variable I created in the <code>SELECT</code> as a <code>WHERE</code> condition.</p>
  
  <pre><code>SELECT first_name.last_name AS name WHERE name="John Doe"
  </code></pre>
  
  <p>What is the best way to accomplish this?</p>