On Wednesday, June 5, 2002, at 10:03 PM, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in > the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for > example. > > You have written the following: > > Hello, > I have a table with 2 columns StartDate and EndDate. > > I can't seem to figure out how to write a select statement that will > tell me if the date I'm searching on is between the Start and the End > date. > > Like, I want to know if 7/4/2002 is between 6/1/2002 (startDate) and > 8/1/2002 (endDate). > > > Thanks, > > - Tom > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php