mysql 獲取一年前的數據

select id,entry_date from t_admin where
str_to_date(entry_date,'%Y-%m-%d') < DATE_SUB(now(), INTERVAL 1 YEAR)