contains()

Returns true if search_string is found within string.

Arguments & returns

4 overloads

Scalar

Overload link	`col0`	`col1`	Returns
#01	`MAP(K, V)`	`K`	`BOOLEAN`
#02	`STRUCT`	`ANY`	`BOOLEAN`
#03	`T[]`	`T`	`BOOLEAN`

Scalar

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

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

CONTAINS_SUBSTR(a, b)

In DuckDB

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