mysql in如何使用方法

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

SELECT * FROM users WHERE city IN ('New York', 'Los Angeles', 'Chicago');

SELECT * FROM users WHERE city IS NULL OR city IN ('New York', 'Los Angeles');

-- 创建示例表
CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE
);

-- 插入示例数据
INSERT INTO orders (order_id, customer_id, order_date)
VALUES (1, 101, '2023-01-01'),
       (2, 102, '2023-01-02'),
       (3, 101, '2023-01-03'),
       (4, 103, '2023-01-04');

-- 使用 IN 查询特定客户的订单
SELECT * FROM orders WHERE customer_id IN (101, 102);