select columnName from tableName where expireColumnDateValue >= Now() -----Original Message----- From: Stephen of Blank Canvas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 10:18 AM To: [EMAIL PROTECTED] Subject: SELECT with DATE
Can anyone point me in the right direction for finding a method of only creating a query that selects records from a dB where today's date is less than the column 'expire', which is in DATE format. The purpose of this is to automatically stop display special offers. Thanks Stephen --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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