SQL 2023 · Changing data
Update rows
Change columns in the rows that match.
UPDATE users SET active = false WHERE last_login < CURRENT_DATE - 365;
Caution: Without a WHERE clause, every row is updated. Run it as a SELECT first to see which rows match.
Official SQL 2023 documentation