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

[Rick James]

Let's get into some more details about what you want.

If your query is always LIKE '/home/x/y/z%', then LIKE is very efficient, perhaps even if you have to have a 'prefix':
INDEX(path(700))

FULLTEXT breaks the string into words. "/" is a word break. Then each word is indexed. Something like "home" will be ignored if half the records have "home". But later fields in the path may be very useful.

FTS can look for certain wildcard words. Matching against 'abc*' will find records with abc123, abcxyz, etc.

> id varchar(50) primary key

Strange PK.