Retrieving between dates
eharetea

Retrieve data between two dates in MySQL.

Using operators in MySQL.

Date Created:Friday August 01st, 2008 12:58 AM
Date Modified:Friday August 01st, 2008 12:59 AM

# search in between dates:
SELECT * FROM table WHERE (date > '2006-03-25 00:00:00') && (date < '2006-03-26 00:00:00');