php - Mysql 组查询错误

Question

我有一些代码可以从 mysql 获取一组结果，请参见下文，

SELECT string, COUNT(string) as myCount 
FROM ip_stats WHERE string != '' OR string IS NOT NULL 
GROUP BY string 
ORDER BY myCount DESC 
LIMIT 10

现在这段代码工作得很好，但是当我添加另一个 where 子句时，如下所示，它返回相同的结果，并且似乎完全忽略了 where 子句的 member = 部分？

SELECT string, COUNT(string) as myCount 
FROM ip_stats WHERE member_id = '000826' string != '' OR string IS NOT NULL 
GROUP BY string 
ORDER BY myCount DESC 
LIMIT 10

如有任何想法或建议，我们将不胜感激。

Answer 1

您的 where 子句有一些错误:

WHERE member_id = '000826' string != '' OR string IS NOT NULL

应该是

WHERE member_id = '000826' AND (string != '' OR string IS NOT NULL)