mysql - 根据日期从数据库中选择行

Question

我在 mysql 表中有一个行列表

+--------+-----+------------+------------+------------+-----------+| off_id | uid | leave_from | leave_to   | leave_code | reason    |+--------+-----+------------+------------+------------+-----------+|      1 |   1 | 2012-01-01 | 2012-01-05 | OFF        | asdsda    ||      2 |   1 | 2012-01-15 | 2012-01-16 | OFF        | asdd      ||      5 |   1 | 2012-02-03 | 2012-02-05 | OFF        | gfjghjhgj |+--------+-----+------------+------------+------------+-----------+

我必须选择日期 2012-01-01 到 2012-01-05 之间的行。我该怎么做，请帮忙。

Answer 1

SELECT * 
FROM tbl
WHERE leave_from >= '2012-01-01'
AND leave_to <= '2012-01-05'