mysql looks for data, but how to find out only the year of the data?
for example, there are data of 2016 create_at, 2017 and 2018 in create_at.
I just want to get 2016, br, 2017, 2018

SELECT
    created_at
FROM
    `blogs` 
where  DATE_FORMAT(created_at,"%Y");