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

[Jigal van Hemert]

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]