狮身人面像搜索问题

Question

group by 和 count 在 sphinx search v 2.0.1B 中不起作用，为什么？

mysql> select count(*) from my_index group by myattr;
ERROR 1064 (42000): sphinxql: syntax error, unexpected FROM, expecting IDENT near 'from my_index group by myattr'

不过，只进行分组而不进行计数就可以了。

Answer 1

试试这个。

select count(*) as cnt from my_index group by myattr;