Full Text Search

alirezaok

i upgraded mysql to lastest version
one of my query worked right in previos version but it doesn't work now.

i have a table with "test" name and 4 fields (id,title,intro,content)
these fields are full text:

CREATE TABLE `test` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` TEXT NOT NULL ,
`intro` TEXT NOT NULL ,
`content` TEXT NOT NULL ,
FULLTEXT (
`title` ,
`intro` ,
`content` 
)
) TYPE = MYISAM ;

i have a record :

INSERT INTO `test` ( `id` , `title` , `intro` , `content` ) 
VALUES (
NULL , 'hello', 'this is a book', 'i am going to school'
);

when i run this query it doesn't have any result in this version:

SELECT * , 
MATCH (
title, intro, content
)
AGAINST (
'is'
IN BOOLEAN
MODE 
) AS score
FROM test
WHERE MATCH (
title, intro, content
)
AGAINST (
'is'
IN BOOLEAN
MODE 
)
ORDER BY score DESC 
LIMIT 0 , 30

any one can help me?

Thanks

Roger_Ramjet

The default is that only words with 4 or more letters will be indexed and searched for. You can change this and must have done so in your old version. So it looks like your settings have been overwritten in the upgrade.