MySQL Select * from TABLE Between DATE RANGE?
Posted on 2009-02-08
I would like to know how to structure and SQL query to query between months ranges
Something along the lines of:
SELECT * FROM table WHERE datetime BETWEEN xx/xx/xx AND xx/xx/xx
We have a table with the following date field entry named datetime:
Which I am assuming is an entry for 2009 02 08 TIME SECONDS or something along those lines
I have read the MySQL Reference on "date" but couldn't make much sense of it - SQL isn't my strong point.
Thanks in advance.