Re: Re: fulltext not for me/alternatives

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" <mark@swiftcamel.com> To: "Ben Edwards" <ben@videonetwork.org> Cc: <php-db@lists.php.net>; <mysql@lists.mysql.com> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net