On Wed, 09 Feb 2005 17:24:10 +0000, love <[EMAIL PROTECTED]> wrote: > alter table table_name add index (birthday);
But would that index improve this kind of query? the docs talk about only direct matchs, like "birthday < now()" or" birthday between x and y". They're all full date values. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]