在MYSQL和PHP中存储和查询数组或词组

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

INSERT INTO my_table (id, data) VALUES (1, JSON_ARRAY('apple', 'banana', 'orange'));

$data = ['apple', 'banana', 'orange'];
$serializedData = serialize($data);
// 将$serializedData存储到数据库中

SELECT JSON_EXTRACT(data, '$[0]') AS first_element FROM my_table WHERE id = 1;

// 从数据库中获取$serializedData
$data = unserialize($serializedData);
// 对$data进行操作