This is a discussion on FULLTEXT searches; min word len within the MySQL forums, part of the Database Server Software category; --> Hi, I've built a database search engine which uses fulltext indexing. But I have a problem regarding the minimum ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I've built a database search engine which uses fulltext indexing. But I have a problem regarding the minimum word length. The web host that my client will be using does not want to decrease the ft_min_word_len variable to 3 in stead of the default 4. (reason invoked: on a shared environment, the index'll get larger and will impair server performance, we should consider a dedicated server). Doing regular searches using the LIKE clause does not care about this limitation. Does using a combination of LIKE and MATCH AGAINST (not in the same query, of course) seems like viable solution? Or is that just nonsense? henri |