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
       <___/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to