mysql - 当它们具有相同的 FROM 时，一个 SELECT 语句而不是两个

Question

我有这个问题:

IF( 125 > (SELECT reputation FROM users WHERE id=new.user_id) OR
    1  <> (SELECT active FROM users WHERE id=new.user_id)
) THEN
   SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = "You need at least 125rep to give downvote.
                                               And your account have to be active.";
END IF;

如何改进 IF 语句中的条件？

Answer 1

我们也许可以合并，如下所示:

SELECT 1 
FROM users 
WHERE id=new.user_id 
AND (reputation < 125 OR (active != 1 OR active IS NULL))

编辑:忽略空事件状态。