用通配符进行过滤

百分号通配符

%表示任何字符出现任意次数

SELECT prod_id, prod_name
FEROM Products
WHERE prod_name LIKE 'Fish%';

 

下划线通配符

SELECT prod_id, pros_name
FROM Products
WHERE prod_name LIKE '_ inch teddy bear';

 

方括号通配符

SELECT cust_contact 
FROM Customers
WHERE cust_contact LIKE '[JM]%'
ORDER BY cust_contact;