On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson <b...@biz-comm.com> wrote: > On 9/28/10 8:33 PM, Chris W wrote: > >> >> SELECT * >> FROM announcements >> WHERE announcements_expiredate > CURDATE() >> AND announcements_postdate <= CURDATE() >> ORDER BY announcements_expiredate ASC
Or how about something like this: SELECT * FROM announcements WHERE CURDATE() between announcements_postdate and announcements_expiredate ORDER BY announcements_expiredate ASC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
