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.
Datum's type is Datetime.
like 2013-11-02 12:21:00
解决方案
Use a between statement, for example:
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.