From: Date: May 28 2003 1:46pm Subject: Re: Select name, email where birthday = ?? List-Archive: http://lists.mysql.com/mysql/140993 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; format=flowed >Hello, I have a date field in my database >Format is YYYY-MM-DD > >Once a day at 12:01AM a script is going to run that will >Select name, email from users where birthday = ?? > >And the ?? Is where I am stuck, I donšt care about the year at all, I just >need to match on the month and day, how would I do this? > >------------------------------------------------------------- >Scott Haneda Tel: 415.898.2602 >http://www.newgeo.com Fax: 313.557.5052 >scott@stripped Novato, CA U.S.A. > You can rewrite the query the following way: Select name, email from users where substring (birthday from 6 FOR 5 )= ??; 6 is the position where it starts from, 5 is the length. _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail