mysql 查询一维数组

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

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

SELECT * FROM users WHERE JSON_CONTAINS(hobbies, '"reading"');

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

INSERT INTO users (id, name, hobbies) VALUES
(1, 'Alice', 'a:2:{i:0;s:8:"reading";i:1;s:9:"swimming";}'),
(2, 'Bob', 'a:2:{i:0;s:6:"gaming";i:1;s:7:"cooking";}');

<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $pdo->query("SELECT * FROM users");
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $hobbies = unserialize($row['hobbies']);
    if (in_array('reading', $hobbies)) {
        echo $row['name'] . ' likes reading.<br>';
    }
}
?>