CODEWITHSUNDEEP
mysqlsphinx
user678070
user678070

Reputation: 1425

sphinx search problem

group by and count doesn't work in sphinx search v 2.0.1B, why?

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'

just group by without the count works though.

Upvotes: 0

Views: 1020

Answers (1)

Iaroslav Vorozhko
Iaroslav Vorozhko

Reputation: 1719

Try this.

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

Upvotes: 1

Related Questions