In preparation for the release of Sphinx 2.1.1, we’re posting this SphinxQL “Cheat Sheet” to give you a taste of what to expect. Brief summary: we added GROUPBY() that returns a grouping key (pretty useful with MVAs), GROUP_CONCAT(), EXIST() to let you query sets of indexes with both existent and non-existent columns, LIKE ‘%substring%’ clause support to SHOW and other statements that can dump a lot of data, added more statistics to SHOW META and a new SHOW INDEX STATUS statement, added UPDATE … OPTION ignore_nonexistent_columns, and a few more things like subselects that we’re going to discuss in the future posts.
Read more…
3 Comments »