Is there HAVING statement in Sphinx?

Subject.开发者_如何学编程

Need to filter after GROUP BY.

P.S: I know, Sphinx is not an SQL-storage alternative :-)

Filtering on attribute values can be used to do something equivalent to SQL's having. Look at section 3.3 of the ref man for your version of Sphinx.

I think the manual for recent versions may be out of date where it says that MVAs can only be 32-bit ints.

From what I could see, Sphinx doesn't have anything like SQL's HAVING statement. Let me know if you find a better answer. I'd be interested.