MySQL Forums
Forum List  »  Full-Text Search

Re: Can I use MySQL FTS index to use with 'Like' operator
Posted by: Rick James
Date: March 05, 2014 11:05PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Can I use MySQL FTS index to use with 'Like' operator
1822
March 05, 2014 11:05PM


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.