contains()

Returns true if search_string is found within string.

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

contains(list, element)

Scalar
Overload link listelement Returns
#01 T[]T BOOLEAN

contains(map, key)

Scalar
Overload link mapkey Returns
#02 MAP(K, V)K BOOLEAN

contains(string, search_string)

Scalar
Overload link stringsearch_string Returns
#03 VARCHARVARCHAR BOOLEAN

contains(struct, entry)

Scalar
Overload link structentry Returns
#04 TUPLEANY BOOLEAN

Example

contains example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.

In other engines

BigQuerycontains_substr()

CONTAINS_SUBSTR(a, b)
In DuckDB
CONTAINS(LOWER(a), LOWER(b))

SQLGlot example โ†—