USE test;

CREATE TABLE data (
    auto json DEFAULT NULL
);

DELETE FROM data;

INSERT INTO data (auto) VALUES ('{"carId": 1, "tripId": 1}');
INSERT INTO data (auto) VALUES ('{"carId": 1, "tripId": 2}');
INSERT INTO data (auto) VALUES ('{"carId": 1, "tripId": 3}');
INSERT INTO data (auto) VALUES ('{"carId": 2, "tripId": 4}');
INSERT INTO data (auto) VALUES ('{"carId": 2, "tripId": 5}');
INSERT INTO data (auto) VALUES ('{"carId": 3, "tripId": 6}');


INSERT INTO data (auto) VALUES ('[
    {"carId": 1, "tripId": 1},
    {"carId": 1, "tripId": 2},
    {"carId": 2, "tripId": 3},
    {"carId": 2, "tripId": 4},
    {"carId": 3, "tripId": 5}
]');


SELECT
    JSON_EXTRACT(auto, '$.carId') carId,
    JSON_EXTRACT(auto, '$.tripId') tripId
FROM data;