month mysql in a where clause code example Example: this month mysql where SELECT * FROM table WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());