snippets
filter:96 snippets
sql-gen-update·sql·general
UPDATE orders
SET status = 'shipped',
shipped_at = NOW()
WHERE id IN (
SELECT id FROM orders
WHERE status = 'paid' AND paid_at < NOW() - INTERVAL '1 day'
);
sql-gen-update·sql·general
UPDATE orders
SET status = 'shipped',
shipped_at = NOW()
WHERE id IN (
SELECT id FROM orders
WHERE status = 'paid' AND paid_at < NOW() - INTERVAL '1 day'
);