From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> ME> IMHO the problem is in this condition ME> ...Field5 LIKE '%John'... > ME> Can you remove it from query and try again?
In fact it was Field5 LIKE '%John%', but "Field5 LIKE '%John'" and "Field5 LIKE '%John%'" don't change query speed at all except about 0.01s .. I try remove it and i was surprised, speed grow and do not decrease. Perhaps because mysql has to analyse more rows before to have enough rows ... Thanks David --------------------------------------------------------------------- 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