O.K. I use MySQL version 3.23 (RedHat 7.0 release) and have a question about
this query:
1.) [...] LIKE '%pattern'
2.) [...] LIKE 'pattern%'
The first query does not use an index while the second does. Is there any
explenation for this?
Thanks.
--
Bolek,
URL: http://www.bolek.com
URL: http://slash.bolek.com
e-mail: [EMAIL PROTECTED]
ICQ: 4086197, Address: 402905326
---------------------------------------------------------------------
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
