SQL

this month mysql where

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

get current month mysql

SELECT *
FROM table
WHERE MONTH(columnName) = MONTH(CURRENT_DATE())
AND YEAR(columnName) = YEAR(CURRENT_DATE())

mysql select month and year

SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;

month mysql

SELECT MONTH("2017-06-15");

mysql select by month

SELECT * FROM Project WHERE MONTH(DueDate) = 1 AND YEAR(DueDate) = 2010