MySQL Forums
Forum List  »  Full-Text Search

Re: MATCH Keywords with Spaces AGAINST Large Text
Posted by: David Allen
Date: December 05, 2021 03:22PM

Unfortunately it's more complex than that because it would pick out single words from inside other words. For example, it would match:

Developer with "eloper" as a keyword. As such, we would need to segregate the words and phrases accordingly, which is why REGEXP is required to define the encapsulates - as we need more than just spaces since people put "eloper" and (eloper) in their resumes. Basically, we need to say:

Match the "Phrase" against any phrase segregated with space, ", ', (), or [].

AFAIK the only way to do that is with REGEXP.

Also, if I use LIKE or REGEXP, which Index is the most efficient?

Options: ReplyQuote

Written By
Re: MATCH Keywords with Spaces AGAINST Large Text
December 05, 2021 03:22PM

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.