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');