1.like
SELECT * FROM Persons
WHERE City LIKE 'N%'
以N开头的
SELECT * FROM Persons
WHERE City LIKE '%g'
以g结尾
SELECT * FROM Persons
WHERE City LIKE '%lon%'
包含‘lon’
2.between
SELECT * FROM Websites
WHERE num BETWEEN 1 AND 20;
结果包括1和20
1.like
SELECT * FROM Persons
WHERE City LIKE 'N%'
以N开头的
SELECT * FROM Persons
WHERE City LIKE '%g'
以g结尾
SELECT * FROM Persons
WHERE City LIKE '%lon%'
包含‘lon’
2.between
SELECT * FROM Websites
WHERE num BETWEEN 1 AND 20;
结果包括1和20