Hi folks, new to the list, hoping I'm posting to the right one.
I've been using the full-text search for a clients site and it works
great... the only problem is I want to change the minimum word length
from 4 to lower, such as 2 or 3. Reading the docs this is simple, and I
followed the instructions I found on various newsgroups and of course
the mysql documentation.
(BTW, I'm using the linux binary distribution of 4.0.4-beta)
Anyway, in /etc/my.cnf I set:
set-variable = ft_min_word_len=3
And then I did an "alter table foo type=MyISAM" as instructed, restarted
mysql, and logged in.
I can see the ft_min_word_len is set to 3 with show variables
| flush_time | 0 |
| ft_min_word_len | 2 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
My table is set up as follows:
CREATE TABLE content (
articledate int(10) NOT NULL default '0',
title varchar(255) default '',
center_content text,
right_content text,
main_content int(10) default '0',
token varchar(64) default '',
UNIQUE KEY sd (articledate),
KEY ti (title),
FULLTEXT KEY txt (title,center_content,right_content)
) TYPE=MyISAM COMMENT='Content Table';
When I execute the following statement, I get results:
mysql> select title from content where match
(title,center_content,right_content) against ('updates');
+-----------------------------+
| title |
+-----------------------------+
| eXI Systems' Latest Updates |
+-----------------------------+
1 row in set (0.00 sec)
But when I try to match on 'exi', I get:
mysql> select title from content where match
(title,center_content,right_content) against ('exi');
Empty set (0.00 sec)
As far as I can tell, this *should* be working. Can anyone help please?
Regards and TIA.
alan
--
Alan "Arcterex" <[EMAIL PROTECTED]> -=][=- http://arcterex.net
"I used to herd dairy cows. Now I herd lusers. Apart from the isolation, I
think I preferred the cows. They were better conversation, easier to milk, and
if they annoyed me enough, I could shoot them and eat them." -Rodger Donaldson
---------------------------------------------------------------------
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
