On Tue, 19 Aug 2003 04:11:32 -0700 (PDT) Rob Sirota <[EMAIL PROTECTED]> wrote:
> Hello, > > I am having a problem when doing a SELECT. Here is the > scenerio: > > I have a table that has an event StartDate and > EndDate, based on the current Date "NOW()" I need to > know which records are currently active. Can anyone > help with a quick SELECT statement? I suppose you need this: SELECT * FROM table WHERE NOW() BETWEEN StartDate AND EndDate; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
