Hi! On Oct 21, Mark Maunder wrote: > Ben Edwards wrote: > > > I have a bit of a problem with using freetext indexes because there are a > > LOT of important 3 letter words in my database and as I am using shared > > hosting so do not have the option to recompile MySql. Can't quite figure > > why 3 is not the default (car, dog, cat war, man, bed, ....). Maybe so you > > would have to recompile to be able to find s_e_x ;). > > Is there a way to get mysql to change the default from 3 to 2 letter words (or > less) that are ignored in fulltext indexes? > I'm running version 4 alpha. I checked the TODO and it's not listed. Is it > possible to make this a config.h option? A minimum of 4 letters for a word to be > included in a fulltext index seems a bit restrictive.
Well, if it's not in the todo, it's probably, already done, isn't it ? See the manual, and SHOW VARIABLES LIKE 'ft_%' 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