LIKE

All functions > COMPARISON > LIKE

Returns TRUE if a string matches a specified pattern with wildcards.

Syntax

string LIKE pattern

Notes

  • Wildcard pattern matching
  • % matches zero or more characters
  • _ matches exactly one character
  • Case-sensitive matching
  • NULL inputs return NULL
  • An escape character can treat % and _ literally (default escape is backslash in the lowering template)

Related Functions

Examples

Basic pattern matching

FeatureQL
SELECT
    f1 := 'hello' LIKE 'h%', -- Starts with 'h'
    f2 := 'hello' LIKE '%o', -- Ends with 'o'
    f3 := 'hello' LIKE '%ll%', -- Contains 'll'
    f4 := 'hello' LIKE 'h_llo', -- Single character wildcard
    f5 := 'hello' LIKE 'world', -- No match
    f6 := 'hello' LIKE 'HELLO' -- Case sensitive
;
Result
f1 BOOLEANf2 BOOLEANf3 BOOLEANf4 BOOLEANf5 BOOLEANf6 BOOLEAN
truetruetruetruefalsefalse

NULL handling

FeatureQL
SELECT
    f1 := NULL::VARCHAR LIKE 'pattern', -- NULL string
    f2 := 'text' LIKE NULL::VARCHAR -- NULL pattern
;
Result
f1 BOOLEANf2 BOOLEAN
NULLNULL

Advanced patterns

FeatureQL
SELECT
    f1 := 'file.txt' LIKE '%.txt', -- File extension
    f2 := '100%' LIKE '100\%' -- Escaped percent
;
Result
f1 BOOLEANf2 BOOLEAN
truetrue

Suggest changes to this page
Last update at: 2026/05/26 17:22:09