On 1 Dec 2003 at 13:41, Kevin Carlson wrote: > Does MySQL support formatted indexes such as in the statement below? > > alter table DateInfo add index monthYear (DATE_FORMAT(updateDate, > '%m/%Y'))
What sort of queries would that help you with? The only thing I can see is if you were trying to find all records with an update date in March without caring about the year, which seems a strange thing to want. If you did consider the month to be the most important part of the update date, then it would be best to make a separate column for it and make a compound index using it. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
