NOT LIKE

All functions > COMPARISON > NOT LIKE

Returns TRUE if a string does NOT match a specified pattern with wildcards.

Syntax

string NOT LIKE pattern

Notes

  • Opposite of LIKE
  • Wildcard pattern matching (%, _)
  • Case-sensitive matching
  • NULL inputs return NULL

Related Functions

Examples

Basic pattern matching

FeatureQL
SELECT
    f1 := 'hello' NOT LIKE 'world', -- No match
    f2 := 'hello' NOT LIKE 'h%', -- Does start with 'h'
    f3 := 'hello' NOT LIKE '%o', -- Does end with 'o'
    f4 := 'hello' NOT LIKE '%ll%', -- Does contain 'll'
    f5 := 'hello' NOT LIKE 'h_llo', -- Does match pattern
    f6 := 'hello' NOT LIKE 'HELLO' -- Case sensitive
;
Result
f1 BOOLEANf2 BOOLEANf3 BOOLEANf4 BOOLEANf5 BOOLEANf6 BOOLEAN
truefalsefalsefalsefalsetrue

NULL handling

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

File extension filtering

FeatureQL
SELECT
    f1 := 'document.pdf' NOT LIKE '%.txt', -- Not a text file
    f2 := 'data.csv' NOT LIKE '%.txt' -- Not a text file
;
Result
f1 BOOLEANf2 BOOLEAN
truetrue

Last update at: 2026/05/26 17:22:09