I have a working search query with new text search functions in DB2 9.5.2:
select * from prevue.mysearchabletable mst where contains(mst.searchabletext, 'porsche') = 1;
However, this only tells me which of them coincide, as well as what the rating is (the rating function was omitted for brevity). Is there a way to use text search in 9.5.2 to highlight search terms?
I know that there were old functions for this in the old Net Search Extender, but I have not yet found equivalents (or workarounds) in the new text search system.
source
share