MySQL选择两个日期之间的所有条目，不考虑年份

Question

我需要在MySQL数据库中查找介于"YYYY-10-30“和"YYYY-12-11”之间的所有行。我不关心日期在哪一年，只是在这两个日期之间。

Answer 1

SELECT *
FROM yourTable
WHERE (MONTH(yourDate) = 10 AND DAYOFMONTH(yourDate) >= 30)
   OR (MONTH(yourDate) = 11)
   OR (MONTH(yourDate) = 12 AND DAYOFMONTH(yourDate) <= 11)

Answer 2

select * 
from table
where
concat(year(now()),right(date_field,6))
between 
concat(year(now()),'-10-30')
and
concat(year(now()),'-12-11')

Answer 3

你能试试这个吗？

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetByMonthAndDayRange`
(
    IN monthFrom INT
  , IN dayFrom INT
  , IN monthTo INT
  , IN dayTo INT
)
BEGIN

  -- For good coding practice, name your columns instead of using *
  SELECT *
  FROM tablename
  WHERE 
     (MONTH(datecolumnname) = monthFrom AND DAYOFMONTH(datecolumnname) >= dayFrom)
  OR (MONTH(datecolumnname) > monthFrom AND      MONTH(datecolumnname) <  monthTo)
  OR (MONTH(datecolumnname) = monthTo   AND DAYOFMONTH(datecolumnname) <= dayTo);

END

如果您使用存储过程(如果代码符合您的口味)，您将能够更快地编写代码，只需提供参数(这种方式是动态的)