MySQL选择两个日期之间的所有条目，而不管年份 [英] MySQL select all entries between two dates regardless of year

问题描述

我需要查找MySQL数据库中YYYY-10-30和YYYY-12-11之间的所有行我不在乎哪一年的日期就在两者之间日期。

I need to find all rows in a MySQL database that fall between "YYYY-10-30" and "YYYY-12-11" I don't care about which year the the date is in just that falls between the two dates.

推荐答案

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

这篇关于MySQL选择两个日期之间的所有条目，而不管年份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！