If I use a REGEXP query on an indexed column using something like: Field REGEXP '^A|^B|^C'
Will MySQL use the index like it would if I used Field LIKE 'A%' or Field LIKE 'B%' or FIeld LIKE 'C%' ?? I could not find this info in the manual. Thanks in advance.... Matthew Dougherty Consultant: Network management architecture and implementation. [EMAIL PROTECTED] Home Office/Cellular: 973-325-8556 http://resumes.dice.com/mdougher --------------------------------------------------------------------- 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