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


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


Sorry, only registered users may post in this forum.

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.