下列用于GLOB中：
- 星号(*) -- 代表零个、一个或多个数字或字符
- 问号(?) -- 代表一个单一的是胡子或字符
语法#
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 '????'
实例#
实例
样例表
SELECT * FROM COMPANY WHERE AGE GLOB '2';
SELECT * FROM COMPANY WHERE ADDRESS GLOB '-*';
