title: Get current year in MySQL WHERE clause
body: <p>How do you get the current year (as a four digit number) for use in a MySql <code>WHERE</code> clause?</p>
  
  <p>I have the following query:</p>
  
  <pre><code>SELECT * FROM tblfeatured WHERE yeargrad LIKE date('Y')
  </code></pre>
  
  <p>The <code>yeargrad</code> columns stores just a year (e.g  2017) and I would like to find rows where this matches the current year.</p>