sql语句 SELECT * FROM table WHERE DATE_FORMAT(date, format) = ‘value’ 注意:table 为表名,date为日期字段,format为格式,格式表如下;value为条件值 根据日查: SELECT * FROM table WHERE DATE_FORMAT(date, “%d”) = ‘01’ 根据月日查: SELECT * FROM table WHERE DATE_FORMAT(date, “%m%d”) = ‘0201’ 其他查询方式以此类推