Hi!
Hank wrote: > 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 The syntax is correct, but I don't think this statement will be optimized as well as the other proposal: BETWEEN is intended for "column BETWEEN const1 AND const2", whereas your statement is "const BETWEEN column1 AND column2". Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
