选择 City
的第一个字母为“a”或“c”或“s”的所有记录。
SELECT * FROM Customers
WHERE City LIKE '@(5)%';
SELECT * FROM Customers
WHERE City LIKE '[acs]%';
SELECT * FROM Customers
WHERE City LIKE '[csa]%';
SELECT * FROM Customers
WHERE City LIKE '[asc]%';
SELECT * FROM Customers
WHERE City LIKE '[cas]%';
SELECT * FROM Customers
WHERE City LIKE '[sac]%';
SELECT * FROM Customers
WHERE City LIKE '[sca]%';