---
title: "MEMBER OF - OceanBase 数据库 V4.5.0 | OceanBase 文档中心"
description: MEMBER OF 描述 如果被检索的元素和 JSON 数组中的任意一个元素相同，则该函数返回 1，否则返回 0。 语法 value MEMBER OF(json_array) 说明 如果 value 是 json_array 的元素，则返回 1，否则返回 0。 value 必须是标量或 JSON 文档；如果它是标量…
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.5.0

# MEMBER OF

更新时间：2026-04-11 18:49:05

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.5.0/zh-CN/700.reference/500.sql-reference/100.sql-syntax/200.common-tenant-of-mysql-mode/400.functions-of-mysql-mode/700.json-functions-of-mysql-mode/200.search-json-text-function-of-mysql-mode/800.member-of-of-mysql-mode.md)  

## 描述

如果被检索的元素和 JSON 数组中的任意一个元素相同，则该函数返回 1，否则返回 0。

## 语法

```sql
value MEMBER OF(json_array)

```

## 说明

如果 `value` 是 `json_array` 的元素，则返回 1，否则返回 0。

`value` 必须是标量或 JSON 文档；如果它是标量，则运算符会将其视为 JSON 数组的元素。

## 示例

```sql
obclient> SELECT 45 MEMBER OF('[123, "abc", 45, "ab", 10]');
+--------------------------------------------+
| 45 MEMBER OF('[123, "abc", 45, "ab", 10]') |
+--------------------------------------------+
|                                          1 |
+--------------------------------------------+
1 row in set

obclient> SELECT 'cd' MEMBER OF('[23, "abc", 17, "cd", 10]');
+---------------------------------------------+
| 'cd' MEMBER OF('[23, "abc", 17, "cd", 10]') |
+---------------------------------------------+
|                                           1 |
+---------------------------------------------+
1 row in set

obclient> SELECT 5 MEMBER OF('[123, "abc", 45, "ab", 10]');
+-------------------------------------------+
| 5 MEMBER OF('[123, "abc", 45, "ab", 10]') |
+-------------------------------------------+
|                                         0 |
+-------------------------------------------+
1 row in set

obclient> SELECT
       45 MEMBER OF('[23, "abc", "45", "ab", 10]'),
      "45" MEMBER OF('[23, "abc", 45, "ab", 10]')\G
*************************** 1. row ***************************
45 MEMBER OF('[23, "abc", "45", "ab", 10]'): 0
"45" MEMBER OF('[23, "abc", 45, "ab", 10]'): 0
1 row in set

obclient> SELECT CAST('[4,5]' AS JSON) MEMBER OF('[[3,2],[4,5]]');
+--------------------------------------------------+
| CAST('[4,5]' AS JSON) MEMBER OF('[[3,2],[4,5]]') |
+--------------------------------------------------+
|                                                1 |
+--------------------------------------------------+
1 row in set

obclient> SELECT JSON_ARRAY(4,5) MEMBER OF('[[3,2],[4,5]]');
+--------------------------------------------+
| JSON_ARRAY(4,5) MEMBER OF('[[3,2],[4,5]]') |
+--------------------------------------------+
|                                          1 |
+--------------------------------------------+
1 row in set

```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线