Hi you can use SELECT * FROM table WHERE expire>NOW();
or SELECT * FROM table WHERE to_days(expire)>to_days(NOW()); HTH Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ ----- Original Message ----- From: "Stephen of Blank Canvas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 18:18 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