Re: MATCH Keywords with Spaces AGAINST Large Text
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.
Subject
Views
Written By
Posted
3222
December 04, 2021 12:25PM
1257
December 04, 2021 08:07PM
1046
December 05, 2021 11:56AM
892
December 05, 2021 12:08PM
969
December 05, 2021 03:22PM
Re: MATCH Keywords with Spaces AGAINST Large Text
2221
December 05, 2021 07:33PM
1204
December 05, 2021 07:45PM
1960
December 05, 2021 08:32PM
912
December 06, 2021 12:18PM
1996
December 22, 2021 10:59AM
809
December 22, 2021 12:30PM
1587
December 06, 2021 12:30PM
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.