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