CODEWITHSUNDEEP
mysqlsearchsearch-enginesphinx
Josh Smith
Josh Smith

Reputation: 15028

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.

alt text

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?

Upvotes: 2

Views: 433

Answers (4)

georgepsarakis
georgepsarakis

Reputation: 1957

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

Upvotes: 0

Riedsio
Riedsio

Reputation: 9926

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

Upvotes: 2

Josh Smith
Josh Smith

Reputation: 15028

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.

Upvotes: 0

Jim Garrison
Jim Garrison

Reputation: 86774

Does this Sphinx function (EscapeString) do what you want

Upvotes: 0

Related Questions