MAP_CONTAINS_VALUE

Description

Syntax

BOOLEAN map_contains_value(Map<K, V> map, V value)

判断给定 map 中是否包含特定的值 value

Example

mysql> select map_contains_key(map(1, "100", 0.1, 2), "1");
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| map_contains_key(cast(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)) as MAP<DECIMALV3(38, 9),VARCHAR(3)>), cast('1' as DECIMALV3(38, 9))) |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|                                                                                                                                                                                1 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.17 sec)

mysql> select map_contains_key(map(1, "100", 0.1, 2), "abc");
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| map_contains_key(cast(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)) as MAP<DECIMALV3(38, 9),VARCHAR(3)>), cast('abc' as DECIMALV3(38, 9))) |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|                                                                                                                                                                                  0 |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.16 sec)

mysql> select map_contains_key(map(1, "100", 0.1, 2), 0.11);
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| map_contains_key(cast(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)) as MAP<DECIMALV3(3, 2),VARCHAR(3)>), cast(0.11 as DECIMALV3(3, 2))) |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|                                                                                                                                                                               0 |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.15 sec)

mysql> select map_contains_value(map(1, "100", 0.1, 2), 100.0);
+--------------------------------------------------------------------------------------------------------------------------------------+
| map_contains_value(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)), cast(100.0 as VARCHAR(3))) |
+--------------------------------------------------------------------------------------------------------------------------------------+
|                                                                                                                                    1 |
+--------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.16 sec)

mysql> select map_contains_value(map(1, "100", 0.1, 2), 101);
+------------------------------------------------------------------------------------------------------------------------------------+
| map_contains_value(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)), cast(101 as VARCHAR(3))) |
+------------------------------------------------------------------------------------------------------------------------------------+
|                                                                                                                                  0 |
+------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.14 sec)

mysql> select map_contains_value(map(null, 1, 2, null), null);
+-------------------------------------------------+
| map_contains_value(map(NULL, 1, 2, NULL), NULL) |
+-------------------------------------------------+
|                                               1 |
+-------------------------------------------------+
1 row in set (0.15 sec)

Keywords

MAP, CONTAINS, VALUE, MAP_CONTAINS_VALUE