mysql 如何存数组

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data JSON
);

INSERT INTO example (data) VALUES ('["value1", "value2", "value3"]');

SELECT data FROM example WHERE JSON_CONTAINS(data, '"value1"');

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data TEXT
);

INSERT INTO example (data) VALUES ('["value1", "value2", "value3"]');

SELECT data FROM example WHERE data LIKE '%"value1"%';

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE example_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    example_id INT,
    value VARCHAR(255),
    FOREIGN KEY (example_id) REFERENCES example(id)
);

INSERT INTO example () VALUES ();
SET @example_id = LAST_INSERT_ID();
INSERT INTO example_data (example_id, value) VALUES (@example_id, 'value1'), (@example_id, 'value2'), (@example_id, 'value3');

SELECT ed.value FROM example_data ed JOIN example e ON ed.example_id = e.id WHERE e.id = 1;

ALTER TABLE example ADD COLUMN data_value VARCHAR(255) AS (data->>'$.value1');
CREATE INDEX idx_data_value ON example(data_value);