SETCONTAINS() function
SETCONTAINS()
returns True when a specified value is found within an IDSET
or STRINGSET
column..
Syntax
SETCONTAINS(
{idset-column, integer-value} |
{stringset-column, 'string-value'}
)
Arguments
Argument | Description | Required |
---|---|---|
idset-column | Column of idset data type to search within | Yes |
integer-value | Single integer value to search for within idset-column | Yes |
stringset-column | Column of stringset data type to search within | Yes |
string-value | Single string value contained in single quotes to search for within stringset-column | Yes |
Returns
Column contains | Data type | Result |
---|---|---|
Specified value | Boolean | True |
Examples
Testing set membership in the select list
Segments table
create table segments
(_id id, segment stringset);
insert into segments(_id, segment)
values (1, ['RED', 'BLUE', 'GREEN']);
+-----+------------------+
| _id | segment |
+-----+------------------+
| 1 | [RED BLUE GREEN] |
+-----+------------------+
This query returns true
.
select setcontains(segment, 'BLUE') as HasBlue
from segments;
Testing set membership as a where clause filter
This query returns true
.
select _id, segment from segments where setcontains(segment, 'BLUE');