How to make a request in the sphinx, like the usual LIKE operator "% somestring%",

Question

I am using sphinx and want to search for elements containing the first AND text containing different text in another column.

I tried this: @Name na @LastName test

But it only returns a string that matches exactly two words, I need results.

Name Test1, Name test2, OtherName lastnametotest,

Any help would be really appreciated,

Thank.

Answer 1

You can use the OR operator for first matches

SELECT * FROM YOUR_INDEX WHERE MATCH ('(@name test1 | test2) @othername lastnametotest');