In the source directory, there's a "myisam/ftdefs.h" file. You can change the min word size there.
Note that you will have rebuild it, and reinstall. Usually via "make/make install." Also you have to rebuild the indicies. Easiest way is to drop and readd them. 'Luck -Szii ----- Original Message ----- From: "Mark Maunder" <[EMAIL PROTECTED]> To: "Ben Edwards" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 21, 2001 8:11 AM Subject: [PHP-DB] Re: fulltext not for me/alternatives > 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. > > tnx! > > > > > -- > 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] -- 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]