Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT name, attributes->'$.color' AS color, attributes->'$.ram' AS ram FROM products; -- JSON_EXTRACT equivalent SELECT JSON_EXTRACT(attributes, '$.color') FROM products;
Result
Open