json_contains

description

Syntax

BOOLEAN json_contains(JSON json_str, JSON candidate)

BOOLEAN json_contains(JSON json_str, JSON candidate, VARCHAR json_path)

BOOLEAN json_contains(VARCHAR json_str, VARCHAR candidate, VARCHAR json_path)

通过返回 1 或 0 来指示给定的 candidate JSON 文档是否包含在 json_str JSON json_path 路径下的文档中

example

1. mysql> SET @j = '{"a": 1, "b": 2, "c": {"d": 4}}';
2. mysql> SET @j2 = '1';
3. mysql> SELECT JSON_CONTAINS(@j, @j2, '$.a');
4. +-------------------------------+
5. | JSON_CONTAINS(@j, @j2, '$.a') |
6. +-------------------------------+
7. |                             1 |
8. +-------------------------------+
9. mysql> SELECT JSON_CONTAINS(@j, @j2, '$.b');
10. +-------------------------------+
11. | JSON_CONTAINS(@j, @j2, '$.b') |
12. +-------------------------------+
13. |                             0 |
14. +-------------------------------+

16. mysql> SET @j2 = '{"d": 4}';
17. mysql> SELECT JSON_CONTAINS(@j, @j2, '$.a');
18. +-------------------------------+
19. | JSON_CONTAINS(@j, @j2, '$.a') |
20. +-------------------------------+
21. |                             0 |
22. +-------------------------------+
23. mysql> SELECT JSON_CONTAINS(@j, @j2, '$.c');
24. +-------------------------------+
25. | JSON_CONTAINS(@j, @j2, '$.c') |
26. +-------------------------------+
27. |                             1 |
28. +-------------------------------+

30. mysql> SELECT json_contains('[1, 2, {"x": 3}]', '1');
31. +----------------------------------------+
32. | json_contains('[1, 2, {"x": 3}]', '1') |
33. +----------------------------------------+
34. |                                      1 |
35. +----------------------------------------+
36. 1 row in set (0.04 sec)

keywords

json,json_contains