Is there a way to identify the keywords in a field (from the database) that were responsible for returning the row based on a select statement.
For example.
select Body from TableName where Body like '+Hockey stick /\RPuck "center ice" skate'
Returns:
The HOCKEY player dropped a STICK next to the Puck near CENTER ICE after a fan hit him in the face with some popcorn.
Looking for a list of words that returned this row. (hockey, stick, Puck, center ice)
thx.
For example.
select Body from TableName where Body like '+Hockey stick /\RPuck "center ice" skate'
Returns:
The HOCKEY player dropped a STICK next to the Puck near CENTER ICE after a fan hit him in the face with some popcorn.
Looking for a list of words that returned this row. (hockey, stick, Puck, center ice)
thx.