mysql - 如何在 MySQL 中排除具有特定 ID 的用户

Question

例如，如何从以下查询中排除 user_id 为 1 的用户？

这是我的 MySQL 代码。

"SELECT users.*, COUNT(*) as coun, users_comments.user_id 
FROM users_comments
INNER JOIN users ON users_comments.user_id = users.user_id
GROUP BY users_comments.user_id 
ORDER BY coun DESC
LIMIT 5"

Answer 1

SELECT users.*, COUNT(*) as coun, users_comments.user_id 
FROM users_comments
INNER JOIN users ON users_comments.user_id = users.user_id
WHERE users.user_id != 1 <---------------
GROUP BY users_comments.user_id 
ORDER BY coun DESC
LIMIT 5