select * from table_name where DATE_FORMAT(table_name.field,'%Y-%m') > DATE_FORMAT(date_sub(curdate(), interval 12 month),'%Y-%m');