mysql fulltext search Can't find FULLTEXT index

[Chris Ward]

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