mysql日期转季节_MySQL：开始和结束日期之间的适当日期范围为两个字段

我有下面的表格叫季节

+----+--------+------------+------------+

| id | cost | start | end |

+----+--------+------------+------------+

| 33 | 255 | 2014-01-05 | 2014-04-16 |

| 17 | 357 | 2014-04-17 | 2014-04-19 |

| 65 | 191.25 | 2014-04-20 | 2014-07-10 |

| 49 | 255 | 2014-07-11 | 2014-08-23 |

| 81 | 191.25 | 2014-08-24 | 2014-12-18 |

+----+--------+------------+------------+我正在尝试使用以下查询来获取开始和结束之间的日期范围。

SELECT

*

FROM

seasons

WHERE

(start BETWEEN '2014-01-05' AND '2014-01-05' OR end BETWEEN '2014-01-05' AND '2014-01-05');如果开始日期恰好在字段上的值开始，我能够得到结果集。

+----+------+------------+------------+

| id | cost | start | end |

+----+------+------------+------------+

| 33 | 255 | 2014-01-05 | 2014-04-16 |

+----+------+------------+------------+现在的问题是，当我提前的日期

2014-01-06

SELECT

*

FROM

seasons

WHERE

(start BETWEEN '2014-01-06' AND '2014-01-06' OR end BETWEEN '2014-01-06' AND '2014-01-06');Empty set (0.00 sec)

没有结果。我怎样才能在SQL中的不同领域之间的日期范围？

任何帮助表示赞赏。