> MySQL doesn't use a table index when doing a string search like %string%,
> but it MAY use the index when doing something string%. Is there a way you
> can change your search to do a "string starts with" instead of a "string
> contains" ? This should help with MySQL using the index that you want it
to
> use.
Also, if you only search on whole 'words' only, eg. 'cisco', 'pc', 'router',
etc. You could of course make a second table where you have split up Title
into words (one entry for each word). In that table you could search without
using like (and therefore use indexes).
--
Aigars
---------------------------------------------------------------------
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
