MySQL选择两个日期之间的所有条目，无论年份如何-MySQLselectallentriesbetweentwodatesregardlessofyear

4  

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

1  

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

1  

Could you try this?:

你能试试吗？：

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)