From: aman raheja
Date: January 3 2003 5:25pm
Subject: comparision in the datetime field
List-Archive: http://lists.mysql.com/mysql/128957
Message-Id: <DAV703JtjfiTdGjv9X80000c290@hotmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi All
I have a datetime field in one of my tables in the MySQL database.
Can I do something like return all records between two certain dates, say
between Nov 02, 2002 and Nov 07, 2002.
Thanks
Aman