Text & patterns
Scalar
contains()
Returns true if search_string is found within string.
Reference: DuckDB 2.0.0
Arguments & returns
4 overloadscontains(list, element)
Scalar
| Overload link | list | element |
Returns |
|---|---|---|---|
| #01 | T[] | T |
BOOLEAN |
contains(map, key)
Scalar
| Overload link | map | key |
Returns |
|---|---|---|---|
| #02 | MAP(K, V) | K |
BOOLEAN |
contains(string, search_string)
Scalar
| Overload link | string | search_string |
Returns |
|---|---|---|---|
| #03 | VARCHAR | VARCHAR |
BOOLEAN |
contains(struct, entry)
Scalar
| Overload link | struct | entry |
Returns |
|---|---|---|---|
| #04 | TUPLE | ANY |
BOOLEAN |
Example
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example ยท Run to view results.
In other engines
BigQuerycontains_substr()
CONTAINS_SUBSTR(a, b)
CONTAINS(LOWER(a), LOWER(b))