On Thu, 6 Mar 2003, Fabian Schmidt wrote:
> Am 05.03.03 schrieb Thomas Spahni:
>
> > Some words like "Tetraeder" have the combination 'ae' and should be found
> > looking for LIKE '%ae%'; surprisingly this works:
>
> Queries with "LIKE '%...'" can't use the index and work correct.
> Unfortunately this is no option for big tables.
you are right, but LIKE 'ae%' does use the index and works.
mysql> explain select * from test where word like 'ae%';
*************************** 1. row ***************************
table: test
type: range
possible_keys: word
key: word
key_len: 255
ref: NULL
rows: 2
Extra: Using where; Using index
Ciao
Thomas Spahni
---------------------------------------------------------------------
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
