Keyword "Hits"

source1ben
Posts: 32
Joined: Fri Nov 02, 2001 10:22 am

Keyword "Hits"

Post by source1ben »

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.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Keyword "Hits"

Post by mark »

Use <fmt "%mH"> to markup the hits or mminfo() to get info about the hits.