Re: MATCH Keywords with Spaces AGAINST Large Text

[David Allen]

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?