MySQL查询以获取开始日期和结束日期之间的结果

Question

我有两个日期说 start_date = 2013-04-12和 end_date = 2013-04-30
我的表包含 start_date = 2013-04-12 的行和 end_date = 2013-04-16

我想获取开始日期大于 2013-04-12 且结束日期小于 2013-04-30 的记录。其中包括以 2013-04-16 为结束日期的上述记录

我试过这个查询

SELECT * FROM TABLE_NAME WHERE (start_date <='2013-04-12' AND end_date >='2013-04-30')这不会给出任何结果但是如果我把 end_date 2013-04-15 它工作正常

Answer 1

SELECT
    *
FROM
    (
        SELECT
            '2013-04-12' as `start_date`,
            '2013-04-16' as `end_date`
    ) `sub`
WHERE
    (`start_date` BETWEEN '2013-04-12' AND '2013-04-30')
    AND
    (`end_date` BETWEEN '2013-04-12' AND '2013-04-30')

BETWEEN 更可靠