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?

Answers


Make sure that asterisks are included in the charset_table.

charset_table = <blah blah blah>, U+002A

http://sphinxsearch.com/docs/current.html#conf-charset-table


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


Need Your Help

full Page Caching on ASP.NET MVC3 with c# and razor engine

asp.net-mvc-3 performance caching

I'm working on large e-Commerce site which is based on ASP.NET MVC3 with C#.I want to do Full Page Caching on all pages like Home page,Categories pages,Product Listing Pages,Product Details pages e...

css selector issue: different background to parent div when checkbox is checked

html css checkbox accordion

I've been trying to solve this for a couple of hours now and it is driving me mad so I hope someone will be able to shed some light on my issue.