Answer: Get records of current month

answer re: Get records of current month

Jan 22 '14

143

This query should work for you:

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

Open Full Answer