42
The LIKE operator
•s LIKE p:  pattern matching on strings
•p may contain two special symbols:
–%  = any sequence of characters
–_   = any single character
•
•Product(PName, Price, Category, Manufacturer)
•Find all products whose name mentions ‘gizmo’:
•
•
SELECT   *
FROM      Products
WHERE   PName LIKE ‘%gizmo%’