title: Select only year from MySql
body: <p>I need to select only the year from the record date. </p>
  
  <pre><code>SELECT *, DATE_FORMAT('release','%Y') AS release_year FROM books
  </code></pre>
  
  <p>but doesnt work. The result in phpmyadmin is NULL.</p>