Name
GLOB — Match text values using patterns
Syntax
Description
The GLOB
operator is used to match text values
against a pattern. If the search expression can be matched to
the pattern expression, the GLOB
operator will return true (1
). All non-NULL parameter
expressions will be converted to text values. GLOB
is case sensitive, so
'a' GLOB 'A'
is
false.
The syntax of the pattern
expression is based off common command-line wildcards, also
known as file-globbing. The *
character in the pattern will match zero or
more characters in the search expression. The ?
character will match exactly
one of any character, while the list wildcard ( []
) will match exactly one
character from its set of characters. All other characters
within the pattern are taken as literals. GLOB
patterns have no escape
character.
For example, the pattern
'*.xml'
will match all
search expressions that end in the four characters .xml
, while the pattern '??'
will match any text value
that is exactly two characters long. The pattern '[abc]'
will match any single
a
, b
, or c
character.
The list wildcard allows a range
of characters to be specified. For example [a-z]
will match any single
lowercase alphabetic character, while [a-zA-Z0-9]
will match any single alpha-numeric
character, uppercase or lowercase.
You can match any character
except those indicated in a list by
placing a ^
at the beginning of the list. For example, the ...
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.