我有一张桌子,像这样:
id trans_date resp_code
------------------------------------------------
1 2011-02-15 12:47:09 1
2 2011-02-24 12:47:09 1
3 2011-02-29 12:47:09 1
4 2011-03-11 12:47:09 1
5 2011-03-15 12:47:09 1
6 2011-03-22 12:47:09 1
7 2011-04-10 12:47:09 1
8 2011-04-11 12:47:09 1我想要的就是获取给定month的所有记录。就像month March[03], I should get row 4,5, and 6一样。
提前感谢……
发布于 2011-05-07 18:21:58
SELECT *
FROM tbl
WHERE trans_date BETWEEN '2011-03-01' AND DATE_ADD('2011-03-01', INTERVAL 1 MONTH)您还可以执行以下查询
SELECT *
FROM tbl
WHERE MONTH(trans_date) = 3
AND YEAR(trans_date) = 2011但它会导致全扫描,因此在处理大量数据时速度会很慢
发布于 2011-05-07 18:25:10
您可以使用MySQL的MONTH()函数
SELECT * FROM tbl WHERE MONTH( trans_date ) = 3https://stackoverflow.com/questions/5920435
复制相似问题