Why is MySQL Full Text Index not working?

Question

After trying everything I could, I finally created this test pattern:

CREATE TABLE test_table (
  id int(11) NOT NULL AUTO_INCREMENT,
  title text NOT NULL,
  PRIMARY KEY (id),
  FULLTEXT KEY title (title)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

With the following test data:

INSERT INTO test_table (id, title) VALUES
(1, 'Evolving intelligence bayesian filtering power behind');

I expect the following query to return 1 row:

SELECT * FROM test_table WHERE MATCH (title) AGAINST ('intelligence');

But it returns an empty set.

I have another database in the same mysql instance where full-text search works as expected. But for every new database that I created, the full text does not work. I rebuilt the indexes, repaired the tables, even checked the index with myisam_ftdump. I have no ideas.

Do you have any ideas on this issue? Thank you in advance.

Answer 1

. (, 1 ), . , 50% .

, "" 100% .

2 "", . mySQL . ( ), .

DC