Link Search Menu Expand Document

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 email
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