Query range of dates in MYsql

[TheFilmGod]

SELECT * FROM calendar_events WHERE datetime BETWEEN '2010-01-01 00:00:00' AND '2010-01-31 23:59:59'

 

A very very very basic SELECT statement that doesn't seem to work. This is part 1 of a complicated JOIN I am doing. But since this doesn't seem to pull up any records from the database, the complicated JOIN will not work.

 

Thanks for your help!

[PFMaBiSmAd]

There is nothing technically wrong with that query.

 

It would take seeing an example of data in the datetime column that you expect to be returned and what the column definition is for anyone to have a chance at telling you why nothing is being returned. Also, how did you execute this query and display the results or otherwise determine that there were no matching rows returned?

 

Edit: Also how is the query being produced, because something like a non-printing character, such as a newline or a null, as part of the '2010-01-01 00:00:00' ... values would prevent a match.