SQL

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