From: "Matt Warden" <[EMAIL PROTECTED]>
On 6/28/05, Joseph Harris <[EMAIL PROTECTED]> wrote:
> I'm following what you write, but the object is to find all names with the
> anniversary - probably on the following day - and that has the need to set
a
> month and month-day for selection. I'm anticipating a list that could be
> in the thousands. On average each day should produce 1/365th of the list
> (and Feb 29 I would send on Feb 28).
Ok. Sorry, I didn't really put together what you were trying to do.
SELECT name, email
FROM foo
WHERE DAY(somedate)=DAY(DATE_ADD(NOW(), INTERVAL 1 DAY))
AND MONTH(somedate)=MONTH(DATE_ADD(NOW(), INTERVAL 1 DAY));
So, return name and email of tuples where the day of somedate is equal
to the day of tomorrow (one day after NOW()) and the month is equal to
the month of tomorrow (one day after NOW()).
Is this what you want?
--
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com
Matt,
Thank you. Yes, I think that will answer my need. I'll test it when
I've got a bit more put together.
Joseph
Joseph Harris
www.smilepoetryweekly.com
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
