MySQL:选择两个日期范围之间的所有数据 [英] MySQL: Select all data between range of two dates

问题描述

如何进行查询以选择两个日期之间的所有内容.

How do I make a query that select everything between two dates.

SELECT * FROM applications WHERE `datum` >='2013-11%' AND `datum`<='2014-04%';

我正在尝试执行类似的操作，但这种操作不起作用，只能返回一条记录.
有人可以告诉我如何使它显示两个日期之间的所有内容.

I was trying to do something like that but that doesn't work that only returns one record.
Can someone show me how to make it show everything between a range of two dates.

基准的类型为日期时间.
就像2013-11-02 12:21:00

Datum's type is Datetime.
like 2013-11-02 12:21:00

推荐答案

使用之间的语句，例如:

SELECT * FROM applications WHERE datum BETWEEN '2013-11-01' AND '2014-04-01';

您在查询中使用通配符，因此只需弄清楚要使用什么日期，就可以轻松滚动.

You are using a wildcard in your queries, so just figure out what dates you want to use and you are good to rock and roll.

这篇关于MySQL:选择两个日期范围之间的所有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！