Spix, search ignoring spaces/dashes

Question

Sphinx

There is a table with records of serial numbers, for example:
01-1048070917-A
V40-30-1004

The data is stored in MySQL, search through Sphinx. How can I make Sphinx search across lines as well, ignoring spaces and dashes, i.e. did you find the serial number from the examples above for "011048070917A" or "V40301004"?

Answer 1

Alternatively, you can play around with a query that sends data to the Sphinx for indexing - it immediately removes spaces and dashes in this field using REPLACE.

Answer 2

there is an ignore_chars directive.

Answer 3

The ignore_chars directive is responsible for which characters will not be indexed at all.
blend_chars is what you need.

Answer 4

It needs blend_chars.
sphinxsearch.com/docs/manual-2.0.1.html#conf-blend-chars