php - 使用一个 SQL 请求更新多行

Question

如何使用一个 SQL 请求更新 10 行

UPDATE gallery_photos SET queue=:queue WHERE id = :id AND SET queue=:queue2 WHERE id = :id2";

类似这样的事情

Answer 1

您可以通过以下方式执行此操作:

UPDATE gallery_photos
    SET queue = (CASE WHEN id = :id THEN :queue
                      WHEN id = :id2 THEN :queue2
                      ELSE queue  -- strictly speaking, this is not not be necessary because of the outer `WHERE`
                 END)
    WHERE id IN (:id, :id2);