Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
UPDATE orders o INNER JOIN customers c ON o.customer_id = c.id SET o.discount = 0.10 WHERE c.membership_level = 'gold' AND o.created_at >= '2025-01-01';
Result
Open