Dealing with asterisks in Sphinx results
I'm using Sphinx to search MySQL.
One of the results Sphinx returns for a search is M*A*S*H, as in the hit television show.
The problem I'm facing is that M*A*S*H is returned for nearly any query made with Sphinx. I'm guessing this is due to the asterisks. If not, then what could the problem be?
If the asterisks are causing my problem, how can I work around this to not have M*A*S*H returned for every query?
Make sure that asterisks are included in the charset_table.
charset_table = <blah blah blah>, U+002A
Does this Sphinx function (EscapeString) do what you want
This problem no longer seems to exist, though I don't know why. I'm sure that something must have been amiss in my sphinx.conf. If someone else has this issue, let me know here and I'll try to update this answer accordingly.
In any case you can use the exceptions file to specify any word you may want to include in your searches. Remember to reindex whenever you change the file.
You can read the details here: http://sphinxsearch.com/docs/1.10/conf-exceptions.html