show only current month entry code example Example: this month mysql where SELECT * FROM table WHERE MONTH(`columnName`) = MONTH(CURRENT_DATE());