mysql字符串in搜索

SELECT * FROM users WHERE city IN ('北京', '上海', '广州');

CREATE TEMPORARY TABLE temp_cities (city VARCHAR(255));
INSERT INTO temp_cities (city) VALUES ('北京'), ('上海'), ('广州');

SELECT * FROM users u JOIN temp_cities t ON u.city = t.city;

SELECT * FROM users WHERE city IN ('北京', '上海', '广州') OR city IS NULL;

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    city VARCHAR(255)
);

INSERT INTO users (id, name, city) VALUES
(1, 'Alice', '北京'),
(2, 'Bob', '上海'),
(3, 'Charlie', '广州'),
(4, 'David', '深圳');

SELECT * FROM users WHERE city IN ('北京', '上海', '广州');