SELECT * FROM table_name
WHERE create_date > (NOW() - INTERVAL 1 YEAR)

使える日付関数
https://dev.mysql.com/doc/refman/5.6/ja/date-and-time-functions.html