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

SETCONTAINSANY() function

SETCONTAINSANY() tests membership of a set of values within a set. It returns true if any of the members of testset exist in targetset

Syntax

setcontainsany(targetset, testset)

Arguments

Argument Description Data type Return value
targetset The set in which the members of testset are being tested for membership. stringset or idset  
testset The set of values to test membership for in the targetset. Match targetset  

Returns

Data type Value
bool True if any member of testset exists within targetset

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 setcontainsany(segment, ['BLUE', 'RED']) as HasBlueOrRed  
    from segments;  

-- Returns: true

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 setcontainsany(segment, ['BLUE', 'RED']);  
+-----+------------------+
| _id | segment          |
+-----+------------------+
|   1 | [RED BLUE GREEN] |
+-----+------------------+