MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.30

CREATE TABLE computers (
  details JSON
)
INSERT INTO computers
VALUES
('{ "name": "Chrome", "os": "Windows", "resolution": { "x": 1680, "y": 1050 } }')
SELECT * FROM computers

details

7b226f73223a202257696e646f7773222c20226e616d65223a20224368726f6d65222c20227265736f6c7574696f6e223a207b2278223a20313638302c202279223a20313035307d7d

SELECT 
  details ->> '$.resolution.x' AS details,
  JSON_EXTRACT(details, '$.resolution.x') AS details 
FROM computers

details
details

1680
1680