With so few rows, are you hitting the 50% rule? Try again with a decent number of rows.
> -----Original Message----- > From: devy [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 04, 2007 5:46 AM > To: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: Fulltext problem > > Hi, > today I've experienced a problem that I don't understand and > I can't solve! > > I've created a table as follows: > --------------- > CREATE TABLE `ft_test` ( > `id` int(11) NOT NULL auto_increment, > `field1` varchar(255) NOT NULL , > `field2` varchar(255) NOT NULL , > `field3` text NOT NULL, > PRIMARY KEY (`id`), > FULLTEXT KEY `field1` (`field1`), > FULLTEXT KEY `field2` (`field2`), > FULLTEXT KEY `field3` (`field3`), > FULLTEXT KEY `f1d2` (`field1`,`field2`) > ) ENGINE=MyISAM CHARSET=utf8; > ----------------- > > and then I've filled this table with the following statement: > ----------------- > insert into ft_test (field1,field2,field3) > VALUES('mysql full text', 'this is a test', 'mysql fulltext'); > ----------------- > > the problem is that when I execute this query I always get 0 > as relevance: > > select *, match(field1) against('mysql') as relevancy from ft_test; > id field1 field2 field3 relevancy > ------ --------------- -------------- -------------- --------- > 1 mysql full text this is a test mysql fulltext 0 > > > I expected a value for relevancy! shouldn't I? > I tested with all other words and combination of fulltext index: > --- > select *, match(field2) against('mysql') as relevancy from ft_test; > select *, match(field3) against('mysql') as relevancy from ft_test; > select *, match(field3) against('fulltext') as relevancy from ft_test; > --- > > but I always get 0! > > This is a "show variables" of my mysql server > Variable_name Value > ------------------------ -------------- > version 5.0.18-nt > ft_boolean_syntax + -><()~*:""&| > ft_max_word_len 84 > ft_min_word_len 4 > ft_query_expansion_limit 20 > ft_stopword_file (built-in) > > > Any advice? > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
