SQL Server FTS: possible to get information how/why rows were matched?
Posted
by jimmy_keen
on Stack Overflow
See other posts from Stack Overflow
or by jimmy_keen
Published on 2010-05-17T18:14:17Z
Indexed on
2010/05/17
20:20 UTC
Read the original article
Hit count: 125
Is it possible to get the information why/how given row returned by FTS query was matched (or which substring caused row to match)?
For example, consider simpliest table with id
and text
columns, with FTS index on the later one.
SELECT * FROM Example
WHERE CONTAINS(text, 'FORMSOF(INFLECTIONAL, jump)');
This examplary query could return, say row {1, 'Jumping Jack'}
.
Now, is it possible to somehow get information that this very row was matched because of 'Jumping'
word? It doesn't even have to be exact information, more of a which substring caused row to match.
Why I'm asking - I got C# app that builds up those queries basing on user input (keywords to search for), and I need the very basic information why/how row was matched back, to use further in C# code.
If it's not possible, any alternatives?
© Stack Overflow or respective owner