Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Given: {"user": {"name": "Alice", "tags": ["admin", "dev"]}} SELECT data->'$.user.name', -- "Alice" data->'$.user.tags[0]', -- "admin" JSON_EXTRACT(data, '$.user.tags[*]') -- ["admin","dev"] FROM settings WHERE id = 1;
Result
Open