SELECT ... FROM table WHERE DAYOFMONTH( NOW() ) = table.day_in_month