Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Build a JSON array SELECT JSON_ARRAY(1, 2, 3); -- [1, 2, 3] -- Append to array UPDATE tags SET list = JSON_ARRAY_APPEND(list, '$', 'new-tag') WHERE id = 1; -- Check if array contains a value SELECT * FROM tags WHERE JSON_CONTAINS(list, '"php"');
Result
Open