I have a MySQL table with the following structure:
I'm wondering, how can I SELECT all records that fall under a specific date/time period?
For example, If i have between Jan 7 at 7:00pm to Jan 9 @ 7pm, I need all records that fall under:
Jan 7 7:00pm to 11:59pm
Jan 8 12:00am to 11:59pm
Jan 7 12:00am to 7:00pm
Any help will be greatly appreciated.