help with mysql date/time query

[miz_luvly@hotmail.com]

i need help to build a SQL query/statement to select only records with a date from now and 1 month before and also from now and two months before?

 

is going to be something like:

 
select * from table where month(date_of_entry )= month(now(-2))

 

 

thanks in advance

[Wildbug]

SELECT * FROM table WHERE date_of_entry BETWEEN NOW () - INTERVAL 2 MONTH AND NOW();