How to Get Current Year Records in MySQL?

Hi Friends,

I am going to explain you example of how to get current year records in MySQL?. You will learn get current year records SQL query. I would like to how to get current year data in MySQL.

Here, i will give you simple example get current year data in MySQL server. I will give you get current year data. This post will give you get current date records in MySQL query.

Let's see bellow example:

Table: users

Solution SQL Query:

SELECT 
	* 
FROM `users` 
WHERE YEAR(created_at) = YEAR(now())

Output:

I hope it will help you...