MySQL选择具有日期的行

使用

DATE_FORMAT

SELECt DISTINCT date, descr FROM book WHERe DATE_FORMAT(date, '%Y %m') = DATE_FORMAT('2012-01-01', '%Y %m')ORDER BY date

或使用

MONTH

YEAR

SELECt DISTINCT date, descr FROM book WHERe Month(date) = Month('2012-01-01')AND Year(date) = Year('2012-01-01')ORDER BY date;

或使用

BETWEEN

SELECt DISTINCT date, descr FROM book WHERe date BETWEEN '2012-01-01'AND '2012-01-31'ORDER BY date;

或使用

<=

>=

SELECt DISTINCT date, descr FROM book WHERe date >= '2012-01-01'AND date <= '2012-01-31'ORDER BY date;

看到这个SQLFiddle