mysql 查找分隔符

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

INSERT INTO users (id, name, hobbies) VALUES
(1, 'Alice', 'reading,swimming'),
(2, 'Bob', 'gaming,cooking');

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

ALTER TABLE users ADD COLUMN hobby1 VARCHAR(255),
ADD COLUMN hobby2 VARCHAR(255),
ADD COLUMN hobby3 VARCHAR(255);

UPDATE users SET hobby1 = SUBSTRING_INDEX(hobbies, ',', 1),
hobby2 = SUBSTRING_INDEX(SUBSTRING_INDEX(hobbies, ',', 2), ',', -1),
hobby3 = SUBSTRING_INDEX(SUBSTRING_INDEX(hobbies, ',', 3), ',', -1);

SELECT * FROM users WHERE hobby1 = 'swimming' OR hobby2 = 'swimming' OR hobby3 = 'swimming';