David,
| | As I understand...after removing "Field5 LIKE '%John'"
| | condition the query works much faster.
|
| Nop, sorry i'm not clear, the query works mush slower ...
This will be fast if you have the right index--
field5 like 'John%'
These will NOT be fast --
field5 like '%John%'
field5 like '%John'
Putting a wildcard character ("%") before the term will avoid the index.
Shashank
Shashank Tripathi
www.shanx.com
Sql, query
---------------------------------------------------------------------
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
