xxxxxxxxxx
SELECT
*
FROM `users`
WHERE MONTH(created_at) = MONTH(now())
AND YEAR(created_at) = YEAR(now())
xxxxxxxxxx
SELECT *
FROM table
WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());
xxxxxxxxxx
SELECT *
FROM table
WHERE MONTH(columnName) = MONTH(CURRENT_DATE())
AND YEAR(columnName) = YEAR(CURRENT_DATE())
xxxxxxxxxx
SELECT * FROM table WHERE MONTH(columnName) = MONTH(CURRENT_DATE())
AND YEAR(columnName) = YEAR(CURRENT_DATE())