title: Can you use an alias in the WHERE clause in mysql?
body: <p>I need to use an alias in the WHERE clause, but It keeps telling me that its an unknown column. Is there any way to get around this issue? I need to select records that have a rating higher than x. Rating is calculated as the following alias:</p>
  
  <pre><code>sum(reviews.rev_rating)/count(reviews.rev_id) as avg_rating
  </code></pre>