Search code examples
sphinx

Using SphinxQL with SphinxSE

Can I actually use sphinxQL with SphinxSE plugin? Like this:

SELECT * FROM t1 WHERE query='SELECT id FROM products GROUP BY region, price';
Solution

  • Nope. Two completely different ways of accessing sphinx.

    SphinxSE under the hood uses the SphinxAPI. 

    SELECT * FROM t1 WHERE query=';select=id;index=products;groupby=attr:region,price';

    Although I dont know if the multiple attribute group by will work.