Reference material for LIKE function
LIKE
is case-sensitive; use ILIKE for case-insensitive pattern matching.
Parameter | Description | Supported input types |
---|---|---|
<expression> | Any expression that evaluates to TEXT . | TEXT |
<pattern> | Specifies the pattern to match (case-sensitive). | TEXT constant. SQL wildcards are supported: * Use an underscore ( _ ) to match any single character* Use a percent sign ( % ) to match any number of any characters, including no characters. |
BOOLEAN
players
table that partially match the string “joe” and any following characters as follows:
LIKE
matches case-sensitively, unlike ILIKE
:
players
table that have a specific pattern: