http://*.com/questions/2526407/complex-query-with-sphinx

比如要实现和如下sql代码相同的功能：

SELECT * FROM table

   WHERE yescolumn = 'query'

   AND othercolumn not like '%keyword%'

You can use Sphinx's extended query syntax to pick the fields you want to search. Try running a query through Sphinx like this:

@yescolumn query @othercolumn -keyword

So in a PHP page you might have a link to a Sphinx database named $sphinx:

$sphinx->SetMatchMode(SPH_MATCH_EXTENDED2);

$results = $sphinx->Query('@yescolumn query @othercolumn -keyword');

更多信息看sphinx的文档关于searching的部分。