SQLite’s GLOB Operator is a text value that matches the pattern specified by a wildcard. If the search expression matches the pattern expression, the GLOB operator returns true, which is 1. Unlike the LIKE operator, GLOB is case-sensitive and follows the syntax of UNIX for the following wildcards.
Asterisk (*)
Question mark (?)
The asterisk (*) represents zero, one, or more numbers or characters. The question mark (?) represents a single number or character. These symbols can be combined. * and? The basic syntax is as follows: You can use the The following examples demonstrate the presence of’* ‘and’?’ Where the GLOB clause of the operator is different: Statement Description Find any value that starts with 200 Find any value that contains 200 anywhere Find any value of the second and third bits that are 00 Find any value that starts with 2 and is at least 3 characters long Find any value that ends in 2 Find any value whose second bit is 2 and ends with 3 Find any value with a length of 5 digits that begins with 2 and ends with 3 Let’s give a practical example, assuming Here is an example that shows This will produce the following results: Here is an example that shows This will produce the following results: 1.21.1. Grammar ¶
SELECT FROM table_name
WHERE column GLOB 'XXXX*'
or
SELECT FROM table_name
WHERE column GLOB '*XXXX*'
or
SELECT FROM table_name
WHERE column GLOB 'XXXX?'
or
SELECT FROM table_name
WHERE column GLOB '?XXXX'
or
SELECT FROM table_name
WHERE column GLOB '?XXXX?'
or
SELECT FROM table_name
WHERE column GLOB '????'
AND
Or
OR
Operator to combine N quantity conditions. Here, XXXX can be any number or string value. 1.21.2. Example ¶
WHERE
SALARY
GLOB
'200*'
WHERE
SALARY
GLOB
'*200*'
WHERE
SALARY
GLOB
'?00*'
WHERE
SALARY
GLOB
'2??'
WHERE
SALARY
GLOB
'*2'
WHERE
SALARY
GLOB
'?2*3'
WHERE
SALARY
GLOB
'2???3'
COMPANY
The table has the following records:ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
COMPANY
In the table
AGE
All records that begin with 2:sqlite> SELECT * FROM COMPANY WHERE AGE GLOB '2*';
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
COMPANY
In the table
ADDRESS
All records in the text that contain a hyphen (-):sqlite> SELECT * FROM COMPANY WHERE ADDRESS GLOB '*-*';
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
4 Mark 25 Rich-Mond 65000.0
6 Kim 22 South-Hall 45000.0