MySql8 试下Json

SET @js = JSON_ARRAY('a', 'b', 'c');


SELECT @js;
SELECT JSON_CONTAINS(@js, 'a', '$')
SELECT JSON_CONTAINS(@js,'"a"','$');

SELECT JSON_CONTAINS(JSON_EXTRACT(@js), 'a', '$');
SELECT JSON_CONTAINS('["a", "b", "c"]', 'a', '$');

SET @j = '{"a": 1, "b": 2, "c": {"d": 4}}';
SET @j2 = '1';
SELECT JSON_CONTAINS(@j, @j2, '$.a');

SELECT JSON_CONTAINS('[1,2,3,4,5]','7','$');
SELECT JSON_CONTAINS('[1,2,3,4,5]','7','$');

// 1
SET @jl = '[1,2,3,4,5]';
SELECT JSON_CONTAINS(@jl,'5','$');

// 0
SET @jl = '["1","2","3","4","5"]';
SELECT JSON_CONTAINS(@jl,"5",'$');

// 0
SET @jl = '["1","2","3","4","5"]';
SELECT JSON_CONTAINS(@jl,'5','$');

// 1
SET @jl = '["1","2","3","4","5"]';
SELECT JSON_CONTAINS(@jl,'"5"','$');

// 1
SET @jl = JSON_ARRAY("1","2","3","4","5");
SELECT JSON_CONTAINS(@jl,'"5"','$');


SELECT id_list INTO @ids FROM t_citizen_relations WHERE obj_id='430728369668380214' AND table_name='T_CYRY' AND field_name='CYRY_ZJHM';
SELECT JSON_CONTAINS(@ids, '"40288805831cbddc01831cc0e5361bcb"');



SET @ids = JSON_ARRAY("a", "b", "c");
SET @path = JSON_SEARCH(@ids, 'all', "a");
SELECT JSON_SEARCH(@ids, 'one', "a");
SELECT JSON_REMOVE(@ids, '$[0]');
SELECT JSON_REMOVE(@ids, JSON_UNQUOTE(JSON_SEARCH(@ids, 'one', "a")));
SELECT JSON_LENGTH(@ids);

SET @ids = JSON_ARRAY("a");
SELECT JSON_LENGTH(JSON_REMOVE(@ids, '$[0]'));