From: Hank
Date: September 29 2010 4:42pm
Subject: Re: Not to show until a certain date
List-Archive: http://lists.mysql.com/mysql/223182
Message-Id: <AANLkTinF9RsX=Qyg-2k55-pu973JaCqUVqu1xUFT7tNW@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
<biz@stripped> 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