ILIKE
Allows matching of strings based on comparison to a pattern. ILIKE is normally used as part of a WHERE clause. ILIKE is case-insensitive; use LIKE for case-sensitive pattern matching.
Syntax
<expression> ILIKE '<pattern>'
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<expression> | The string to evaluate for matches. | TEXT |
<pattern> | Specifies the pattern to match (case-insensitive). 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. | TEXT |
Return Type
TEXT ARRAY
Example
Find nicknames from the players table that partially match the string “Joe” and any following characters as follows:
SELECT
playerid, nickname, email
FROM
players
WHERE
nickname ILIKE 'Joe%';
Returns:
| playerid | nickname | |
|---|---|---|
| 160 | joedavis | cgarcia@example.org |
| 519 | joe79 | jennifer10@example.net |
| 3692 | joeli | cperez@example.net |
| 3891 | joel11 | joanncain@example.net |
| 4233 | joellong | millerholly@example.net |
| 4627 | joebowen | amandalewis@example.net |