contains()

Returns true if the list contains the element.

Arguments & returns

3 overloads

Scalar

Overload link	`list`	`element`	Returns
#01	`ANY[]`	`ANY`	`BOOLEAN`

Scalar

Checks if a map contains a given key.

Overload link	`map`	`key`	Returns
#02	`MAP(ANY, ANY)`	`ANY`	`BOOLEAN`

Scalar

Returns true if search_string is found within string.

Overload link	`string`	`search_string`	Returns
#03	`VARCHAR`	`VARCHAR`	`BOOLEAN`

SELECT contains('abc', 'a');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  contains([1, 2, NULL], 1);

SELECT
  contains(MAP {'key1': 10, 'key2': 20, 'key3': 30}, 'key2');

CONTAINS_SUBSTR(a, b)

In DuckDB

CONTAINS(LOWER(a), LOWER(b))