Merlin wrote:
I am wondering if it is possible to find words inside words with the
help of fulltext search.
Is this possible? Google does that, so somehow there should be a way.
Somehow I don't think that Google runs on a single MySQL database. Full
text indexes in MySQL mean that words (MySQL's definition of a word
that is) are indexed, not parts of words.
Google's purpose is to provide a searchable index, so they have built
their own data structures for these features.
Another thing is, how do I exclude popular words like and for and
similar from the search? Is there a MySQL setting for this. Like
words_to_exclude =
Fine tuning full-text search can be found at:
http://dev.mysql.com/doc/mysql/en/fulltext-fine-tuning.html
The default stop words are at:
http://dev.mysql.com/doc/mysql/en/fulltext-stopwords.html
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]