Skip to main content Link Menu Expand (external link) Document Search Copy Copied

SETCONTAINS() function

SETCONTAINS() tests membership of a value within a set expression.

Syntax

setcontains(set, value)

Arguments

Argument Description Data type Return value
set The set in which value is being tested for membership. stringset or idset  
value The value to test membership for in the set. value must be assignment compatible with the element type of the set.    

Returns

Data type Value
bool True if value is member of set.

Examples

Testing set membership in the select list

This query returns true.

create table segments  
    (_id id, segment stringset);  

insert into segments(_id, segment)  
    values (1, ['RED', 'BLUE', 'GREEN']);  

select setcontains(segment, 'BLUE') as HasBlue  
    from segments;  

Testing set membership as a where clause filter

create table segments  
    (_id id, segment stringset);  

insert into segments(_id, segment)  
    values (1, ['RED', 'BLUE', 'GREEN']);  

select _id, segment from segments where setcontains(segment, 'BLUE');  
+-----+------------------+
| _id | segment          |
+-----+------------------+
|   1 | [RED BLUE GREEN] |
+-----+------------------+