Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
START TRANSACTION; -- Preview first SELECT COUNT(*) FROM orders WHERE status = 'pending' AND created_at < '2024-01-01'; -- Then update UPDATE orders SET status = 'expired' WHERE status = 'pending' AND created_at < '2024-01-01' LIMIT 500; COMMIT;
Result
Open