Can I use MySQL FTS index to use with 'Like' operator

[Pratheesh TU]

I created a table as follows:

create table docdb ( id varchar(50) primary key, path text not null,
PRIMARY KEY (`id`),
FULLTEXT KEY `path` (`path`))


I want to query the 'path' column which have values like: '/opt/home/docs', '/home/var/data', etc...

Can I use MySQL FTS index to use with 'Like' operator.

I want to query - select * from docdb where path like '/home/var%'; I have to use 'path' column as a text, because varchar limit is around 712 chars for indexing. So making FTS index for Like will be a good idea!! Please comment...

Also a normal index on path and FTS index on path has any performance difference with 'Like' operator?