mysql 查询json

SELECT * FROM `article`
 
WHERE JSON_CONTAINS(tags, '["Mysql"]');


UPDATE `article`
 
SET tags = JSON_MERGE(tags, '["dev"]')
 
WHERE
 
JSON_SEARCH(tags, 'one', 'dev') IS NULL
 
AND
 
JSON_SEARCH(tags, 'one', 'Mysql') IS NOT NULL;


插入数据

JSON_REPLACE(doc, path, val[, path, val]…)
替换数据

JSON_ARRAY_APPEND(doc, path, val[, path, val]…)
向数组尾部追加数据

JSON_REMOVE(doc, path[, path]…)