On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi to all,
hi I have to build a search of products on web catalog site. It has to search > a whole words to avoid when somebody search for a pin and get "*pin*k > shirt". > I was suggested to use MATCH() AGAINST() and it works perfect - until I > dscovered that I'm getting alwayes 0 results if search for cap, pen, mug - > three-letter words. Since, these are one of the most searched words (we > are in promotin industry) it's a big problem for me. > I found on http://dev.mysql.com/doc/refman/4.1/en/fulltext-boolean.html > that the default value of minimum character length is 4?!?!? > > Does anybody solved this problem? > is there any other solution to suggest? You should simply add this line to your mysql configuration file: ft_min_word_len=3 and then you should rebuild the index of your table with: REPAIR TABLE <table_name> QUICK Thanks for any help. > > -afan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- http://www.openwebspider.org http://www.eviltime.com - " Time is what we want most, but what we use worst "
