mysql某字段等于两个值

SELECT * FROM users WHERE status IN ('active', 'pending');

SELECT * FROM users WHERE status = 'active' OR status = 'pending';

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    status VARCHAR(20)
);

INSERT INTO users (id, name, status) VALUES
(1, 'Alice', 'active'),
(2, 'Bob', 'pending'),
(3, 'Charlie', 'inactive'),
(4, 'David', 'active');

SELECT * FROM users WHERE status IN ('active', 'pending');

SELECT * FROM users WHERE status = 'active' OR status = 'pending';