title: Compare result of 'as' expression in 'where' statement
body: <p>Is it possible to create a MySQL select statement that uses an expression as x then checks if the value for x is under a certain amount?</p>
  
  <pre><code>SELECT (mytable.field1 + 10) AS x FROM `mytable` WHERE x &lt; 50;
  </code></pre>