Get current year in MySQL WHERE clause

Question

How do you get the current year (as a four digit number) for use in a MySql WHERE clause?

I have the following query:

SELECT * FROM tblfeatured WHERE yeargrad LIKE date('Y')

The yeargrad columns stores just a year (e.g 2017) and I would like to find rows where this matches the current year.

Answer 1

You can use curdate() function to get today's date and then use year() function on it to get the current year.

SELECT * FROM tblfeatured WHERE yeargrad = year(curdate());