get records from database based on a month code example

Example 1: this month mysql where

SELECT *
FROM table 
WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());

Example 2: mysql get last 2 month data

SELECT * FROM d_jobs WHERE  `job_date` >= last_day(now()) + interval 1 day - interval 3 month;