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');

CREATE TEMPORARY TABLE temp_cities (city VARCHAR(255));
INSERT INTO temp_cities (city) VALUES ('New York'), ('Los Angeles'), ('Chicago');

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

SELECT * FROM users u WHERE EXISTS (SELECT 1 FROM cities c WHERE u.city = c.city);

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

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