title: MAX function in where clause mysql
body: <p>How can I use max() function in where clause of a mysql query, I am trying:</p>
  
  <pre><code> select firstName,Lastname,MAX(id) as max where id=max;
  </code></pre>
  
  <p>this is giving me an error:</p>
  
  <pre><code>Unknown column 'max' in 'where clause'
  </code></pre>
  
  <p>Any Help? Thanks in advance.</p>