mysql存储数组对象

SELECT * FROM table WHERE JSON_EXTRACT(serialized_data, '$.key') = 'value';

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

INSERT INTO example (data) VALUES ('[{"key": "value1"}, {"key": "value2"}]');

SELECT * FROM example WHERE JSON_EXTRACT(data, '$[0].key') = 'value1';

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

CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    product VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (name) VALUES ('Alice');
INSERT INTO orders (user_id, product) VALUES (1, 'Product A');

SELECT users.name, orders.product FROM users JOIN orders ON users.id = orders.user_id;

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

INSERT INTO example_json (data) VALUES ('{"array": [{"key": "value1"}, {"key": "value2"}]}');

SELECT * FROM example_json WHERE JSON_EXTRACT(data, '$.array[0].key') = 'value1';