Good day!
The essence of the title of the question.It is the words and stemes, not the field!='Word'
And is it possible to use this with thinking_sphinx in RoR?
So far, I did it stupidly - I take id records with the right words, I exclude from them id records with words-exceptions.Two requests are received, clumsily and slowly, and even problems have arisen when the received id became too much.
  • And what's not to like about the condition in the query, such as
    ...where is some_field not in(<exceptions word list>)
    – Ashamed Anteater Nov 12 '17 at 19:03
  • This is not what you need.
    According to the words we are looking for through MATCH('word') and we would like to exclude by the same logic.Or I don’t understand the NOT IN statement in sphinxQl? In any case, I didn’t have what I expected.
    For example:
    We have two entries with the following titles:
    Selling sour milk

    Selling fresh milk

    Looking for the"milk" steme and I expect to receive these two records
    I don’t want to get milk with sour milk, so I would like to exclude the"procis" stem
    I receive by your example the query
    WHERE MATCH('milk') AND title NOT IN('prokis')

    And he returns nothing
    – Precious Pintail Nov 12 '17 at 19:16

1 Answers 1

it would be better if you still

clean the sphinx push yourself off, with correctly configured tuners

MATCH('Milk! Prokis')

  • And do not tell me, is it possible to somehow implement the condition of the form(("phrase1" |"phrase2") AND(!"Phrase3" |!"Phrase4")) in MATCH? – Precious Pintail Nov 12 '17 at 22:22
  • try to expand the brackets
    1! 3! 4 | 2! 3! 4
    but in general, on the issue, logic is lame
    – All-Star Jetski Nov 12 '17 at 22:51
  • All-Star Jetski, yes, that's it.Thanks for the help! – Precious Pintail Nov 13 '17 at 08:08