DML

INSERT

INSERT INTO users (name, age) VALUES ('Alice', 30);
INSERT INTO users (name, age) VALUES ('Bob', 25), ('Carol', 40); -- multi-row

UPDATE

UPDATE users SET age = age + 1 WHERE name = 'Alice';
UPDATE users SET status = 'active' WHERE age >= 18 AND age < 65;
UPDATE users SET status = 'banned' WHERE name IN ('eve', 'mallory');

DELETE

DELETE FROM users WHERE age < 18;
DELETE FROM users WHERE name LIKE 'spam%';

All three support any combination of comparison operators, AND/OR/NOT, IN, LIKE, IS [NOT] NULL in WHERE.