Timestamp comparison in MySQL for same months / different years -

i'm using sql query 3 tables data analysis. need compare timestamps 3 months- jan, feb, march on different years.

my code far clause is:

a.time_stamp between '%y%/10/01 00:00:00' , '%y%/01/01 00:00:00' 

and not returning right result. thoughts?

mysql lets select month date:

select month(now()); // -> 1 (in january) 

so might try (not tested):

where month(a.time_stamp) >= 1 , month(a.time_stamp) <=3