mysql查询json数组中包含

MEMBER OF()示例

基本用法

SELECT
    1 MEMBER OF('[1, 2, "a"]'),
    'a' MEMBER OF('[1, 2, "a"]');

+----------------------------+------------------------------+
| 1 MEMBER OF('[1, 2, "a"]') | 'a' MEMBER OF('[1, 2, "a"]') |
+----------------------------+------------------------------+
|                          1 |                            1 |
+----------------------------+------------------------------+

纯值

如果 和 都是纯值且相等，那么 返回 。valuejson_arrayMEMBER OF()1

SELECT
    1 MEMBER OF('1'),
    'a' MEMBER OF('"a"'),
    CAST('true' AS JSON) MEMBER OF('true');

+------------------+----------------------+----------------------------------------+
| 1 MEMBER OF('1') | 'a' MEMBER OF('"a"') | CAST('true' AS JSON) MEMBER OF('true') |
+------------------+----------------------+----------------------------------------+
|                1 |                    1 |                                      1 |
+------------------+----------------------+----------------------------------------+

这里使用了 CAST（） 函数将 由字符串转为 JSON 值。'true'

注意：本文归作者所有，未经作者允许，不得转载