WHERE month number mysql code example
Example 1: this month mysql where
SELECT *
FROM table
WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());
Example 2: month mysql
SELECT MONTH("2017-06-15");
SELECT *
FROM table
WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());
SELECT MONTH("2017-06-15");