mysql 循环查询逗号分隔

SELECT * FROM table_name WHERE FIND_IN_SET('value', column_name);

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

INSERT INTO users (id, name, hobbies) VALUES
(1, 'Alice', 'reading,swimming'),
(2, 'Bob', 'football,reading'),
(3, 'Charlie', 'swimming');

SELECT * FROM users WHERE FIND_IN_SET('reading', hobbies);

CREATE TABLE user_hobbies (
    user_id INT,
    hobby VARCHAR(255),
    PRIMARY KEY (user_id, hobby),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO user_hobbies (user_id, hobby) VALUES
(1, 'reading'),
(1, 'swimming'),
(2, 'football'),
(2, 'reading'),
(3, 'swimming');

SELECT u.* FROM users u JOIN user_hobbies uh ON u.id = uh.user_id WHERE uh.hobby = 'reading';