BSON_
On this page
Returns a SingleStore TINYINT 1 if the specified value is present in the BSON array.
Syntax
BSON_ARRAY_CONTAINS_BSON(<array>, <value>)Arguments
-
<array>: A BSON array or an expression that evaluates to a valid BSON array. -
<value>: The value to find in the array.
Return Type
SingleStore TINYINT type.
Remarks
-
If the specified
<array>argument is not a valid BSON array, returnsNULL. -
If the specified
<array>argument is SQLNULL, returns 0. -
If the specified
<value>is present in the<array>, returns 1, otherwise 0.
Examples
Note: The following examples explicitly cast string to BSON for clarity.
SELECT BSON_ARRAY_CONTAINS_BSON('[true,"abc",123]':>BSON, '123':>BSON) AS Result;
+--------+
| Result |
+--------+
| 1 |
+--------+SELECT BSON_ARRAY_CONTAINS_BSON('[{"a":1,"b":2},"abc",123]':>BSON, '{"b":1,"a":2}':>BSON) AS Result;
+--------+
| Result |
+--------+
| 0 |
+--------+SELECT BSON_ARRAY_CONTAINS_BSON('{"a":12,"b":23}':>BSON, '123':>BSON) AS Result;
+--------+
| Result |
+--------+
| NULL |
+--------+Last modified: April 3, 2024