I am still finding the suggestions so far, and any scripts I have been able to find, don't address what I want - not efficiently anyway. DATE_FORMAT() will convert to useable data from DATE or DATETIME, but then this has to be processed again to extract the instances of the date required. That might be ok for a couple of hundred records.
But let us say there are 10,000; I want all the emails of 1/365th of the entries each day. There will be nothing else I want to do with the birthdata. So, despite rudy's insistence, I still think that three columns - year, month, day - will enable much more rapid extraction and avoid confusion with the year. AmI wrong, or is it just a matter of preferences (i.e will I trip up with my idea?). 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.
