At present using our Sphinx / fultext search on our discussion forum only recognises and flags up to us key word matches of product names or alias / nicknames in a (separate database) if they are at the front of the search query text string.
Using the product "Shure SM57" as an example
"Shure SM57 microphone, is it good for vocals?" - is detected
"Can I use my Shure SM57 microphone for vocals?" - is not detected.
Can ES be configure to flag up key words mid query string?
What about multiple product mentions with in a query string?
"Can't decide between buying an SM57 or a U87 please advise"
Could it be made to flag up detection of both?
Further - say a discussion thread has 30 products mentioned per web page - is ES a good tool to detect and flag up and output each of the products that are detected "live" at the time of every visitors page load? (When started the discussion thread may only refer to one or two products but as other members add to it with their posts more products will be added) or is this an inefficient method?
For clarity there is a discussion database and a separate product database to reference to.
Many thanks in advance for the beginner question