mysql : How to get data from last July to Current date

Question

我知道如何获取 7 月份的数据

SELECT * FROM tableName 
   WHERE MONTH(created) = 7

但是我怎样才能获得去年七月至今的数据呢？

Answer 1

根据您的查询，我会选择:

SELECT * FROM tableName 
WHERE MONTH(created) = 7 
AND (
( MONTH(CURDATE()) <= 7 AND YEAR(created) = YEAR(CURDATE()) - 1 )
OR 
( MONTH(CURDATE()) > 7 AND YEAR(created) = YEAR(CURDATE()) )
)

如果您想要(就像您在评论中所要求的那样)自那​​时起的数据，请选择:

SELECT * FROM tableName 
    WHERE created <= CURDATE()
    AND (
    (
    MONTH(CURDATE()) <= 7
    AND created >= DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-07-01'), INTERVAL 1 YEAR)
    )
    OR
    (
    MONTH(CURDATE()) > 7
    AND created >= DATE_FORMAT(CURDATE(), '%Y-07-01')
    ));