title: Using aliased result of function in where clause
body: <p>I want to pull specific rows from a table where the date matches a certain date. First I'm converting the date string to date format, here's the query:</p>
  
  <pre><code>SELECT id, str_to_date(candidate.AddDate,"%d/%m/%Y") n FROM candidate WHERE n='2016-01-01';
  </code></pre>
  
  <p>But I get the error "Unknown column 'n' in WHERE clause"</p>
  
  <p>How do I make the query use the result of str_to_date in the where clause?</p>