MySQL Forums
Forum List  »  Full-Text Search

Re: MATCH Keywords with Spaces AGAINST Large Text
Posted by: Peter Brawley
Date: December 05, 2021 07:33PM

Yes to avoid substrings you'd need regex or a correcting Where condition, and note that the Where condition can use regex.

> f I use LIKE or REGEXP, which Index is the most efficient?

Unfortunately, with Regexp or with Like and a leading wildcard, none.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MATCH Keywords with Spaces AGAINST Large Text
307
December 05, 2021 07:33PM


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.