LIKE
All functions > COMPARISON > LIKE
Returns TRUE if a string matches a specified pattern with wildcards.
Syntax
LIKE(expr1, expr2[, escape])sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
string | VARCHAR | Yes | String expression to test |
pattern | VARCHAR | Yes | Pattern string with wildcards (% for any characters, _ for single character) |
escape | VARCHAR | No | Optional escape character to treat wildcards literally |
Returns
BOOLEAN - TRUE if string matches pattern, FALSE otherwise
Notes
- Uses SQL wildcard pattern matching
%matches zero or more characters_matches exactly one character- Case-sensitive matching
- NULL inputs return NULL
- Use ESCAPE clause to treat wildcard characters literally
- Common escape character is backslash ()
- Can be used with operator syntax:
string LIKE pattern