SQLite
Of LIKE Operator is a text value that matches the pattern specified by a wildcard. If the search expression matches the pattern expression, the
LIKE
operator returns true, which is 1. There are two wildcards associated with the
LIKE
Operator is used together:
Percent sign (%)
Underscore (_)
百分号（%）代表零个、一个或多个数字或字符。下划线（_）代表一个单一的数字或字符。这些符号可以被组合使用。 % and _ The basic syntax is as follows: You can use AND or OR operators to combine N quantities of conditions. Here, XXXX can be any number or string value. The following examples demonstrate the value of the Statement Description WHERE SALARY LIKE ‘200%’ Find any value that starts with 200 WHERE SALARY LIKE’% 200%’ Find any value that contains 200 anywhere WHERE SALARY LIKE’_ 00%’ Find any value of the second and third bits that are 00 WHERE SALARY LIKE’2%’ Find any value that starts with 2 and is at least 3 characters long WHERE SALARY LIKE’% 2’ Find any value that ends in 2 WHERE SALARY LIKE’_ 2% 3’ Find any value whose second bit is 2 and ends with 3 WHERE SALARY LIKE’2 million dollars 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.20.1. Grammar ¶
SELECT column_list
FROM table_name
WHERE column LIKE 'XXXX%'
or
SELECT column_list
FROM table_name
WHERE column LIKE '%XXXX%'
or
SELECT column_list
FROM table_name
WHERE column LIKE 'XXXX_'
or
SELECT column_list
FROM table_name
WHERE column LIKE '_XXXX'
or
SELECT column_list
FROM table_name
WHERE column LIKE '_XXXX_'
1.20.2. Example ¶
LIKE
Where the clause is different:
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 LIKE '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 LIKE '%-%';
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
4 Mark 25 Rich-Mond 65000.0
6 Kim 22 South-Hall 45000.0