SELECT * FROM tabella
WHERE campo_date between NOW() - INTERVAL 3 MONTH and NOW()