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
I have a table with the following date field entry named datetime:
Which I am assuming is an entry for 07-05-2009 (d/m/Y)
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.