MySQL Forums
Forum List  »  Full-Text Search

mysql fulltext search Can't find FULLTEXT index
Posted by: Chris Ward
Date: April 27, 2009 09:15AM

Hi,,

I have been trying to improve my search script and am trying to get full text working. I want to be able to search through some address. I have simplified itinto a 2 column table for testing and it still doesn't work. any help would be appreciated


CREATE SQL STATEMENT:
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`address` varchar(255) character set utf8 NOT NULL,
PRIMARY KEY (`id`),
KEY `address` USING BTREE (`address`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

MY SQL STATEMENT:
SELECT * FROM test WHERE
MATCH(`address`) AGAINST('road')

it givs an error of:
1191 Can't find FULLTEXT index matching the column list

I ma using mysql query browser but i dont see how that would effect it. I cant for the life of me work out what is wrong with it?

Chris

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql fulltext search Can't find FULLTEXT index
10588
April 27, 2009 09:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.