Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT JSON_SEARCH( '{"colors": ["red", "blue", "green"]}', 'one', -- "one" = first match, "all" = all matches 'blue' ); -- Returns: "$.colors[1]"
Result
Open