Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT p.name, jt.tag FROM products p, JSON_TABLE( p.attributes->'$.tags', '$[*]' COLUMNS (tag VARCHAR(50) PATH '$') ) AS jt WHERE p.id = 1;
Result
Open