like¶
Description¶
Returns true if subject matches pattern (case-sensitive).
Within pattern, escape can be included to denote that the character following it be interpreted literally.
The arguments pattern and escape must be string literals. The argument pattern may include wildcards _ (matches exactly one character) and % (matches zero or more characters). If included, escape may only be a single character. If using backslash as the escape character, it must be escaped in the escape clause (see example).
Return type¶
bool
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
like(subject, pattern, [ escape ])
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
subject |
string |
no |
no |
none |
pattern |
string |
no |
no |
constant |
escape |
string |
yes |
no |
constant |
Examples¶
filter like(@.bundle_kind, "%kube%")
Pass through all bundle kinds that contain the string ‘kube’.
filter like(@.bundle_kind, "k^%__", "^")
Pass through all bundle kinds that are 4 characters long and begin with ‘k%’.
filter like(@.bundle_kind, "k\\%__", "\\")
Pass through all bundle kinds that are 4 characters long and begin with ‘k%’.