M
M
Mikhail2019-01-25 11:58:54
Sphinx
Mikhail, 2019-01-25 11:58:54

How to properly configure search in shpinx by word forms?

Good afternoon, the question arose, I can’t force sphinx to search by word forms
For example, I drive in “black gabardine”, “black gabardine” - and it gives out different positions
There are 3 and there are 3 others, what could be the snag in the config?

source products
{
      type          = mysql
      sql_host      = localhost
      sql_user      = user
      sql_pass      = pass
      sql_db        =  bd_name
      sql_port        = 3306

      sql_query_pre        = SET NAMES utf8
      sql_query_pre        = SET CHARACTER SET utf8

      sql_query            = SELECT id, product_code, name, supplier_article FROM products
      sql_field_string = name
}

index products_index
{
      source            = products
      path              = /var/lib/sphinxsearch/data/products_index
      min_word_len       = 2
      min_infix_len = 2
      morphology        = stem_enru, Soundex, Metaphone
      expand_keywords = 1
      index_exact_words = 1
        charset_table = 0..9, A..Z->a..z, _, a..z, \
    U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
      html_strip = 1
}

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Puma Thailand, 2019-01-25
@opium

Look at the normalized forms of your queries

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question