I inherited a large table (50 million records) with the date stored as an integer in the format (mmddyyy). The dates go back to the 1800's and in the 1990's so the year is either 8xx or 9xx.
I need to be able to search by partial dates. For example, some searches need to pull every record for the month of June. What is the best way to search? Do I need to separate the date into different columns (day, month, year)? I have tried wildcard searches, but they seem to do an entire table scan and are very slow. Thanks, Jeff --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
