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 BOOLEAN | f2 BOOLEAN | f3 BOOLEAN | f4 BOOLEAN | f5 BOOLEAN | f6 BOOLEAN |
|---|---|---|---|---|---|
| true | false | false | false | false | true |
NULL handling
FeatureQL
SELECT
f1 := NULL::VARCHAR NOT LIKE 'pattern', -- NULL string
f2 := 'text' NOT LIKE NULL::VARCHAR -- NULL pattern
;Result
| f1 BOOLEAN | f2 BOOLEAN |
|---|---|
| NULL | NULL |
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 BOOLEAN | f2 BOOLEAN |
|---|---|
| true | true |