如何在MySQL中查询逗号分隔的字符串值？

CREATE TABLE my_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    comma_separated_values VARCHAR(255)
);

INSERT INTO my_table (comma_separated_values) VALUES
('apple,banana,cherry'),
('banana,orange'),
('apple,grape'),
('cherry,grape,banana');

SELECT * FROM my_table
WHERE FIND_IN_SET('banana', comma_separated_values) > 0;

SELECT * FROM my_table
WHERE comma_separated_values LIKE '%banana%';

SELECT * FROM my_table
WHERE comma_separated_values REGEXP '(^|,)banana(,|$)';

CREATE TABLE my_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    json_values JSON
);

INSERT INTO my_table (json_values) VALUES
('["apple", "banana", "cherry"]'),
('["banana", "orange"]'),
('["apple", "grape"]'),
('["cherry", "grape", "banana"]');

SELECT * FROM my_table
WHERE JSON_CONTAINS(json_values, '"banana"');