From: "Rhino" <[EMAIL PROTECTED]> > I don't know if it is more efficient but I would write this query as > follows, simply because it is easier to understand what it is doing when you > look at it: > > select [whatever columns you want] > from mytable > where month(birthdate) = 11 > and dayofmonth(birthdate) = 7;
Sorry, same speed (approx 0.18 sec). This seems to be the speed at which a full tablescan can be performed on this recordset. I guess we have to make some adjustments before the table can grow to 500,000+ records... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]