mysql - About sphinx segment rules -


when use sphinx, found results not quite accurate.

for example, in mysql table, there records 'test1', 'test2', 'test.zip', 'test_zip', 'test-zip' when search 'test', got 'test.zip' , 'test-zip'. , if want 'test1' in result, have search 'test1' explicitly

so question is, why sphinx not consider test1 'test' , '1', , if want search results including part of full word, how that?

the default charset_table, sets letters, numbers , underscore word charactors, else seperator.

so test1 indexed "test1" test-zip indexed "test zip"

there infix/prefix indexing http://sphinxsearch.com/docs/current.html#conf-min-infix-len can match part words. (sphinx default matches whole words)

if want change charset_table, numbers not considered word charactors (but wouldnt able search numbers!) - @ same time want not include underscore - taht test_zip considered 2 words.

you instead put numbers in blend_chars - taken seperators too.

finally use regexp_filter split words , numbers separate words.

... 4 possible solutions, possibly worthwhile try each one, , decide works best overall.


Comments

Popular posts from this blog

java - activate/deactivate sonar maven plugin by profile? -

python - TypeError: can only concatenate tuple (not "float") to tuple -

java - What is the difference between String. and String.this. ? -