Hi! On Oct 26, Oscar Nelson wrote: > At 09:40 PM 10/26/2001 +0200, Sergei Golubchik wrote: > >Hi! > > > >On Oct 26, Oscar Nelson wrote: > > > Full text searches in MySQL are limited to 4 characters or more. Is there > > > any simple > > > work around to lower this limit to three characters or more? If there is > > > not, does anyone have any pointers as to where I should start poking around > > > in the code? > > > >Yes! But these pointers are hidden deep inside MySQL manual :-) > >Look for them in the "Fulltext search" section. > > I've been through this section of the manual, starting with: > http://www.mysql.com/doc/F/u/Fulltext_Search.html which states that, > "Any 'word' that is present in the stopword list or just too short (3 > characters or less) is ignored." > > I didn't make myself really clear in my question. I would like to include > words that are 3 characters in a FULLTEXT index.
http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html It's for 4.0.0 if you have 3.23 - consult the same section in your local copy of the manual. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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
