I want to hightlight the search word (hits) in the search results. I use the fulltext search with e.g. where contains(html, 'formsof(INFLECTIONAL, search word)')
.
How I get the right hits from the SQL server to highlight them in the frontend?
I could not find an optimal solution for me. I have already tested the following things:
Is there a good solution (script, library) for highlighting search hits? Also like a commercial solution.