sql - 将查询中每一行的 bool 值设置为 FALSE 'HAVING' ?

Question

(对标题的措辞感到抱歉。)

我有以下 SQL 查询来检索我想要的所有行:

SELECT
    app_activity.name 
FROM
    app_chatmessage
JOIN
    app_activity ON app_chatmessage.activity_id = app_activity.id
GROUP BY
    app_activity.name
HAVING
    COUNT(app_chatmessage.owner_id) = 1;

现在，表 app_chatmessage 也有一个列 seen。对于上述查询返回的所有行，我想将此列设置为 FALSE。我该怎么做？

Answer 1

试试这个

Update app_chatmessage set seen='FALSE' where
activity_id in 
(
SELECT
    app_activity.id
 FROM
     app_chatmessage
 JOIN
      app_activity ON app_chatmessage.activity_id = app_activity.id
 GROUP BY
     app_activity.name
 HAVING
     COUNT(app_chatmessage.owner_id) = 1
);