how to get last 3 months data in mysql code example
Example 1: mysql get last 2 month data
SELECT * FROM d_jobs WHERE `job_date` >= last_day(now()) + interval 1 day - interval 3 month;
Example 2: mysql last 6 months
.... where yourdate_column > DATE_SUB(now(), INTERVAL 6 MONTH)