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.
精彩评论