mysql 3个月,MySQL选择过去3个月的记录

what will be the smartest way to select all rows from MySQL table for the past 3 months if the table has the following columns:

| id (int) | year (int)| month (int) |

Considering that if the current month & year are for example 2.2016 I need to select all records for 11.2015 & 12.2015 & 1.2016

It is easy if the current month is greater than 3 because all months that I need to select are in the same year so I can subtract 3 from the current month and run simple query

SELECT * FROM mytabe where year=2016 and month >= xx

解决方案Select * from mytable where STR_TO_DATE(concat(year,"-",month,"-01"),'%Y-%m-%d')>date_sub(curdate(),Interval 3 month) ;

The above query will get fetch year and month from date 3 months before today