mysql last three months code example
Example 1: mysql 3 months ago
date_created >= NOW() - INTERVAL 3 MONTHExample 2: mysql last 6 months
.... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)date_created >= NOW() - INTERVAL 3 MONTH.... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)