mysql查找数据，怎么只查出数据的年份，如下图

Question

问题 mysql查找数据，怎么只查出数据的年份，例如现在的create_at中有2016，2017，2018年份的数据，我只想得到2016,2017,2018 代码 SELECT created_at FROM `blogs` where DATE_FORMAT(created_at,'%Y');

Answer 1

SELECT
    YEAR(created_at)
FROM
    `blogs`;

Answer 2

year(created_at) in (2016,2017,2018)

Answer 3

SELECT FROM_UNIXTIME(created_at, '%Y') FROM blogs

Answer 4

select left(create_at,0,4) from blogs;

Answer 5

select distinct(year(created_at)) from blogs;