Re: efficient query for: "it's your birthday today"

[Remo Tex]

NB! ...WHERE doycol=312
Valid only for dates <= 28.Feb
OR Dates > 29.Feb but not in leap year(s) ;-)
> doycol=DAYOFYEAR("2004-11-07")
>
> or
>
> doycol=312
Eric McGrane wrote:
How about adding another column that stores the day of year for the
birthday.  You could then index on this column and your query would be for
11/7 would be
doycol=DAYOFYEAR("2004-11-07")
or
doycol=312
E
""Jigal van Hemert"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I have date of birth stored in a DATETIME column and need to find for
which
persons a certain date is their birthday.
I've tried so far:
   DATE_FORMAT (col, '%m%d') = '1107'        => 0.2001 sec
   col LIKE '%-11-07%'        => 0.1643 sec
   col RLIKE '-11-07'        => 0.1702 sec
Are there faster alternatives for MySQL 4.0.21 ?
Regards, Jigal.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]