开发者

Is there HAVING statement in Sphinx?

开发者 https://www.devze.com 2023-03-13 10:27 出处:网络
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 havi

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号