get month from now mysql code example Example: this month mysql where SELECT * FROM table WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());